Run Macro from a Different Access Database97

[Shyla J K]

Hi,

I have a problem while calling a Macro which is in a
different database.

We have 17 Access97 databases. Each database is having
lots of Macros. Instead of opening each access database we
thought of having a single database which calls all the
macros from those 17 databaseS.
So, we are having an 18th database which should call all
the Macros which are in the 17 databases.
I tried lots of things like making those 17 databases as
Library databases(Module --> Tools -> References) and
using in the Run Macro Action method of the 18th database.
Please suggest a better method of doing it.

Thanks
Shyla

 

[cgalla]

I am trying to do a similar thing and would be interested in any
solutions suggested.

Thank you.
Christopher

 

[Steve Schapel]

You can run a macro in another database by using a RunApp action in a
macro in the active database. The Command Line argument of the RunApp
action will use syntax such as this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDb\MyDB.mdb" /x NameOfMacro

 

[Ed Picillo]

Steve, I am having some trouble with this syntax "/x name of macro" after
converting to Access 2003. Do you know of any reason why the /x name of
macro will not work with Access 2003? Is there another solution?

 

[Douglas J. Steele]

What's the exact command line you're using?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Steve, I am having some trouble with this syntax "/x name of macro" after
converting to Access 2003. Do you know of any reason why the /x name of
macro will not work with Access 2003? Is there another solution?