Using ADO.vba to access MsProject 2002 MPP data

[Jim Zeeb]

I believe in MsProject 2002 they added the capability to access the MsProject
data directly using ADO without having to open the MPP file.
I looked in the SDK and the example there uses Access.DataAccessPages, but
does not show how to use this capability from within VBA.
I tried to set up an ODBC source, but MsProject was not listed as one of the
options.

Any help, sample code would be appreciated.
inTHANKSadvance!

 

[Jim Zeeb]

After rooting around some, I found the following document was installed as
part of MsProject 2002:
C:\Program Files\Microsoft Office\Office10\1033\PRJOLEDB.HTM

This explains how to use ADO from within VBA to access project data.