Opening Excel from Access using VBA

[supanoods]

Sorry in advance if this thread has been covered somewhere - but I have searched and searched for ages, and found nothing!

What is the VBA to open an Excel SS from Access 97??

I am stumped

Thanks in advance!

"If it aint broke - dont fix it!

 

[rubbernilly]

Here are a couple of threads with code examples...

For automating Excel:

http://www.tek-tips.com/viewthread.cfm?qid=1137585&page=2

And this thread for various ways to get data into Excel:

http://www.tek-tips.com/viewthread.cfm?qid=1137319

HTH

 

[supanoods]

Thanks for the pointers - but it is not what I am wanting to do (or at least I am getting it wrong!)

All I want to do is literally open an Excel document

I have been trying excel.workbooks.open (filename)
(and i have chosen the correct resources in access too)

Thanks

"If it aint broke - dont fix it!

 

[supanoods]

SORTED!!!!!

http://www.tek-tips.com/viewthread.cfm?qid=90756&page=1

picked the bones out of this - thanks

Steve

"If it aint broke - dont fix it!