Archive of Mr Excel Message Board

Back to Other Office and Excel archive index
Back to archive home

opening an excel file programmatically from access

Posted by Pat on August 10, 2001 12:14 PM

How do you open an excel file from access programmatically ??

Any help would be appreciated....

Thanks

Re: opening an excel file programmatically from access

Posted by Russell Hauf on August 10, 2001 1:29 PM

A few ways to go about it -- the link below does the job...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno97ta/html/msdn_autooff.asp

Also: Go down to where it says: Automating Excel (nm)

Posted by Russell Hauf on August 10, 2001 1:30 PM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.