Running a macro from another database

[camiller]

Does anyone know if its possible to run a macro in database 1 from database 2?

Thanks

 

[FancyPrairie]

Try this:

' Include following in Declarations section of module.
Dim appAccess as Access.Application

Function OpenMacro(strMacroName as string)

Set appAccess = _
CreateObject("Access.Application&quot
' Open database in Microsoft Access window.
appAccess.OpenCurrentDatabase "path\YourDbName.mdb"
' Open Macro
appAccess.DoCmd.RunMacro strMacroName

End Function

 

[Elysium]

One more thing to add: go to this link -

http://www.mvps.org/access/forms/frm0034.htm

This code is for a form, but you can easily substitute the form call with a macro call.

RS

 

[chrissie1]

read this thread

thread702-455987 Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong