run macro from different database

G

Guest

I want to run a macro while working in a different database. I do not want to
have to open the databased run the macro then return to the other database.
 
G

Granny Spitz via AccessMonster.com

sierralightfoot said:
I want to run a macro while working in a different database. I do not want to
have to open the databased run the macro then return to the other database.
Click to expand...

You can write a procedure that will do this for you, like this:

Public Function runMacroOtherDB() As Boolean
Call Shell("C:\Program Files\Microsoft Office\OFFICE10\MSAccess.exe " & _
"C:\db1.mdb /x mcrOpenQuery1", vbMinimizedNoFocus)
runMacroOtherDB = True
End Function
 

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

Similar Threads

Call a macro from commandline with existing autoexec 1
active a macro from a different database while working in another 1
Run Macro If Cell have "x" value 0
Compact & Repair, Open table, close table, then run macro 3
MS Access 2007 - Macro Action to Open Another Database 1
Call Access macro using Excel VBA 1
Run Macro From Another Database 2
how do i send report by email upon closing database 3

Top