Running Macro in Excel from Access

[sorcerer11]

Hi,

I have an access database that exports a reports data using the Output To command, then I have created a series of Macro's in Excel and placed them in the Personal.XLS file. Since they need to run for many different excel file names.

The Excel Macros work fine, but after Access run's the OutPut To command I am unable to figure out how to get access to run the macros on the excel sheet.

The Code I'm using follows

DoCmd.OpenReport "Rpt_SelectiveReport_Detailed", acViewPreview

DoCmd.OutputTo acOutputReport, "Rpt_SelectiveReport_Detailed", acFormatXLS, "K:\Export to Excel\DailyReport.xls", 1

At this point I wish to run a macro contained in the XLS file.

Does anybody have any ideas.

Thanks

 

[sorcerer11]

Sorry the third line from the bottom should read

"At this point I wish to run a macro contained in the Personal.XLS file."