How to run MS Project macro through MS Access?

[Manuel Recao]

Hello all,

My team and I are developing an application in MS Access that opens an MS Project and copy its timeline view. We have a macro within MS Project that when we run, we are able to copy its timeline view. However, we want our MS Access application to allow managers to search an MS Project file, run its macro, and have the timeline view ready on their clipboard to paste.

Is there a way to run a macro in MS Project from MS Access when opening a project file?

Thank you.

[Author]

Posts