I have an Access database/procedure that exports data to an Excel
spreadsheet and opens that spreadsheet using automation
I need to change the current directory/drive in Excel to be the same as
that of the spreadsheet I've created so that the user is in the correct
place in Excel when the Access procedure finishes.
I know of ChDrive() and ChDir() but how do I manipulate these functions
in my Excel Application object from Access?
------
Sean
"If at first you don't succeed, go to sleep"
*** Sent via Developersdex http://www.developersdex.com ***