How to open a Project Server 2007 project plan from Excel VBA macr

D

Dave

One of our Project Managers has an Excel file that runs a macro and populates
the spreadsheet with data obtained from an open Microsoft Project V2007 .mpp
file. We are migrating these .mpp files over to Project Server and now need
to adapt his macro to accomdate this change.

I am not a programmer by any stretch... Can someone help me with the coding
modification needed in the Excel macro to basically open a Project Server
based project plan rather than the file-based .mpp MS project file?

Once the project plan is open in the Microsoft Project client application,
the remainder of the Excel macro should be able to run without modification.

Thank you very much in advance.
Dave
 
R

Rod Gill

Hi,

No need to open the plan in Project from Project Server. provided the file
has been published din Project Server you can read the data directly from
the reporting db from Excel VBA using OLEDB. Search MSDN for sample code for
reading SQL Server data using oledb.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project 2010 "Project has stopped working" error when attempting to import from Excel 0
How to create a Header at the top of my MS Project 2013 plan? 3
Convert Project Server 2007 published plan to MPP 1
Generate mpp file from Project Server 9
Cannot open MS Project 2003 file from VB.NET 1
How to connect Project to a profile 3
Backup Project from project server 2007 4
Converting Project 2003 MDB File to Project 2007 1

Top