Using VBA in Access to get Data From MS Project

[Karlgh]

HELP !!!

How can i do this,
i would like to open a .mpp file find the data i want and send it to a field in Access.

can somebody help Please

Karl

 

[Dodgey]

You have to include the Powerpoint Object library into your database and program for this. If this is new to you, good luck. It takes a bit of work to do first time out.

 

[scking]

Correction. You need to reference the Microsoft Project COM control. If your needs are simple you could open Project and create macros which would help you learn the Project Object model and programming in Project. For automation from Access merely create the Project.Application object and go from there. This is not a simple task, learning a new object model from experimentation and there are almost NO books describing Project programming. Good luck. -------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------