How to execute macro in another database

[101287]

Can someone direct me to article, code etc. on how to execute a macro that is in another database. For example; I have open a specific database (1) and would like to connect to another datase base and execute a macro.

Guidance will be appreciated.

Luis

 

[Ed2020]

You can build a command line to open MS Access, open a specified database (with workgroup and logon credentials passed as parameters) and then then use the /x switch to specify a macro name.

The format of your command line is something along the lines of:

<MSAccess.exe filepath> <database filepath> <workgroup filepath> /user <user name> /pwd <user password> /x <macro name>

Once the command line is created execute it using the Shell() function.

Ed Metcalfe.

Please do not feed the trolls.....

 

[101287]

Can you please provide additional information or an example? I tried to put the command together but has not being able to make it work.

Thank you for patence.

 

[Ed2020]

You can find instructions and examples in the following knowledgebase article:

http://support.microsoft.com/kb/209207

HTH,

Ed Metcalfe.

Please do not feed the trolls.....

 

[101287]

Thank you Ed. The article really help me understand your suggestion.