Executing MS Excel Macro from MS Access

fulltime

Registered User.
Local time
Today, 23:12
Joined
Mar 24, 2006
Messages
56
After exporting an EXCEL file from MS access, how can i call MS EXCEL to open up automatically and execute a macro to be run on the file tat i exported? I have done the "export" part of the codes in MS Access. I need help on how to open MS excel n run the macro.. thks..

Eg.

I export test.xls from access. Then after exporting, I want MS excel to run Macro1 on test.xls in the background.

Regards
FT :)
 

Users who are viewing this thread

Back
Top Bottom