Jason W said:
I have a macro in an Access database that I would
like to call in a macro I'm creating for excel. How
do I do that? And is it possible to do without
opening Access?
Access and Excel macros are not compatible, and you can't directly call one
from the other.
In fact, the only way I know for you to execute an Access macro is to open
an Access database. You can use the command line argument /X to specify a
macro to be run at startup; or open an Access database with code in an event
of the specified Startup Form that runs the macro you want. In Access 2003
Help, the search terms "command line option" will give you information on,
well, "command line options".
Explain what it it that you are trying to accomplish, and perhaps someone
can make a useful suggestion.
Larry Linson
Microsoft Office Access MVP
