Run excel macro from an access macro

M

MarySue

From an Access macro I want to open an Excel spreadsheet and run an enbedded
excel macro.
What code do I write to execute the excel macro when I write the code to
"runapp" from access.

The macro is run using "cntrl-x" when the spreadsheet is open.

The file resides at: c:\My Documents\My Databases\import.xls

Thanks in advance for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top