API actions from MS Access

[AndreQ]

I wanted to know of a method to perform MSP actions from Access where the
Access VBA code opens the specific instance of an MSP file and then performs
actions (such as Save As) and closes down again. Its MSP version 10 (2002)
and not project server.

Thanks
AndreQ

 

[Rod Gill]

Use Automation, just as you would to control Excel.

Set a reference to the project object library then:

Dim projApp as MSProject.Application
Dim proj as MSProject.Project
Set projApp=createobject("MSProject.Application")
projapp.fileopen "FilePath"
Set proj=projApp.ActiveProject

Record macros in Project to get most of your remaining code. All code needs
to be preceded by projApp or proj

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx