View Full Version : Access project table directly via VBScript or VBA?


dgmoore@erols.com
02-21-2006, 08:52 PM
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
02-21-2006, 11:19 PM
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.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


<dgmoore@erols.com> wrote in message
news:1140555139.455431.206890@z14g2000cwz.googlegroups.com...
> 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
>