Trying to acccessing the MSPROJECT Library from VBA in Access

[Guest]

Hi,
Does anyone know how to access the MSPROJECT Library from Access. By that I
don't mean opening a Project from Access, but opening the actual Library.

What I want to do is loop through all the various properties in the library
from which I can then create an empty Access table. From there I want to be
able to read the property values from a project and drop them into the Access
Table.

The first challenge is can I access the MSPROJECT library from VBA.
The next challenge is to understand how I could use the property names from
the library to reference the properties in the project.

 

[Guest]

Did you try to reference the MSProject Library in Access already?
Then you have access to the object model of MSProject and thus are you able
to retrieve all the available properties.

 

[Guest]

Yes, I have no problems doing this, what I want to do is to NOT have to
explicity type each property into the module and then save it to the table.
I want to be able to somehow loop through the properties and write the values
out. In the same way you can loop through a collection.

 

[Guest]

Isn't there a properties collection provided?
Normally there is for each object.

 

[Guest]

not for Project, not that I can find anyway...

I'll keep looking though...

Thanks Raoul

 

[Guest]

I think you will have to load a project through the lib so you get a project
document and this will probably give access to some attributes or properties
collection.

I don't have MSProject installed so I can't check.