Trying to access Project Server information from Excel

[Moses Bunting]

I am trying to write a little VBA macro that will open each published project
on the server, one at a time, and loop through the tasks and assignments.

The only piece that I'm missing is how to actually get access to the
project. Whenever I use the FileOpen method, Project give me an error that
I'm trying to access a project on the server, but I haven't logged on.

How do I establish a connection for the Project Server account that will
allow me to open the projects?

 

[Rod Gill]

If you just want to read data, try creating Views in SQL server based on the
MSP_VIEW tables then read directly from them using DAO or OLEDB recordsets.