Solved - Running Macro After Access Export

[Samnuni]

Hi all, I have followed this thread: http://www.mrexcel.com/board2/viewtopic.php?t=280561&highlight=excel+vba where I was successful in exporting a query into Excel.

I have also made a macro: OpenQuotationCleanUp.bas which cleans up and formats the data for me.

I would like to know if it is possible to link the export module and the Excel macro together. Please advise.

Thanks in advance.

-- Sam

 

[giacomo]

how do you mean link them together?

 

[Samnuni]

I would like to run the Excel macro whenever I have exported the file without having to go to Excel myself and manually trigger the macro.

 

[giacomo]

Take a look at this article from the Microsoft Knowledge Base: ACC97: How to Run Macros in Other Office Programs

hth,
Giacomo

 

[Samnuni]

Awesome, thanks!