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
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
