Run macro in excel from command button in access

[Jameo]

Hi all,

I have an access database. A user runs a query from access which returns data. The data is then exported into excel. A series of macro's in excel then arrange and plot charts from the data.

Is there anyway to automate this whole process from access?

i.e. the macro would run the processes in access, open the relevent excel workbook, and then run another macro that initiate all the excel macros.

Not sure if this possible or not, but any help would be greatly appreciated.


Thanks