How to run MS Project macro through MS Access?

[mirl98]

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.

[Gicu]

As MS Project also uses VBA I am sure you can run that macro or a replacement VBA equivalent from Access using simple Office automation (OLE).
https://docs.microsoft.com/en-us/off...timelineexport

Cheers,

[ranman256]

Since I do not have Ms Project , I do not know the exact object names.
but its similar to this example:

in VBE (alt-F11)in Tools ,References
checkmark (add) the MsProject object library
then the code will be like:

dim prj as MsProject.Application
Set prj = CreateObject("MsProject.application")
with prj
   .open  "c:\myProject.prj"
end with