Call MSP macro from Excel macro

S

SpaceCamel

I would like to execute a macro in MSP from a macro in Excel.

How to I do that?

Thank,
 
R

Rod Gill

Hi,

Try the Application.run method - the application in this case is the Project
Application object.
 
S

SamB

In your excel macro, create a reference to the MSProj object model. In the
VBE, choose Tools, References and select the Microsoft Project version Object
Library.

Then in the excel procedure, instantiate an MSP app object:

Sub sam()
Dim appMSP As New MSProject.Application

appMSP.Macro ("msproject macro name")

End Sub
 
Top