Access 2000 VBA - Run Macro -[RESOLVED]-

[MAB]

Can anyone tell me how to run a macro from Outlook, Word or Excel from Access 2000 using VBA? Thank you.

[RobDog888]

You can add a reference to whatever Office app your wanting to run a macro of.

'Add reference to MS Excel xx.0 Object Library
Private Sub Command1_Click()
    Dim oApp As Excel.Application
    oApp.Workbooks.Open "Book1.xls"
    oApp.Visible = True
    oApp.Run "MyMacro", "Argument1", "Argument2" ', etc.
End Sub

HTH

[MAB]

Thanks very much!

[RobDog888]

No prob. Anytime.

Ps, dont forget to Resolve this thread as a courtesy to other members.