How do you invoke an Excel macro from an Access macro?

[Macro Builder]

Use an Access macro to open an Excel file and run the
macro within the Excel file and close the file when done,
thereby finally returning to the Access macro. Please
provide the correct syntax to write in the command line of
the 'RunApp' action in the Access macro design window.
Thankyou
p.s. Please post the answer only. No emails please.

 

[Douglas J. Steele]

I'm not sure you can do it through an Access macro. You can, however, do it
using VBA.

Check http://www.mvps.org/access/modules/mdl0007.htm at "The Access Web" for
one approach.

 

[Ken Snell]

To add to Douglas' comment, I'm not aware either of any way to run an EXCEL
macro from an ACCESS macro. You must use VBA and Automation to do this.