How to programatically call a macro in a different (ie. external) Access database using VBA?
I want to use Access Database1 to call a macro in Access Database2.
The link below describes how to call an external macro in a visio program, but the syntax seems to be a little different with Access.
Basically, I want to do something like this (from within database 1)
Does anybody know how to do this?
You could use the built in Shell command to call your secondary database, and pass it the macro name in the command line switch, this would force your secondary database to execute the desired macro on open. More about Access command line switches can be found here: