Module code for running a .xls macro from Access

D

Dan T

This is my first attempt at creating an ACCESS Module and
I need some help.

I want to create an ACCESS Module that will;
Step 1. Open an EXCELL file (myfilename.xls), excute an
EXCEL Macro (MYMACRO)and then close and exit EXCELL
(MYMACRO already saves the file).
Step 2. then excute an ACCESS macro.

Once I get this Module completed all the user will have to
do is excute the Module from a button on the SwitchBoard
manager.

Thanks in advance for your help.

Dan T
 

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