Access project table directly via VBScript or VBA?

[dgmoore]

1. Is there a way to access the tasks table in an mpp file directly
using VBScript to pull out task names and start/finish dates?

2. Is there a way to attach directly to Project tables, or to query
Project tables, e.g. from Access, other than declaring an object and
iterating through the table rows using VBA, or saving the mpp as an mdb
and getting at the tables in that manner?

Thanks
Dave

 

[Rod Gill]

Hi,

In Project 2000+ you can use OLEDB to read .mpp files directly. Project 2007
doesn't have this capability any more.

See pjoledb.htm in one of Project's program folders (or the CD) for details.