Accessing Project list collection with VBA?

[Ugur KARATAS]

Hi All,

I need to collection of projects with using VBA, which resides on Project
Server.

I can open Project Open Dialog only but i need the collection for my custom
project guide.

 

[Rod Gill]

Hi,

Try searching msdn.microsoft.com for info on PDS for Project Server. This is
the best way to interrogate Project Server as it will automatically only
return the projects the logged on user is entitled to see. Failing that,
read the MSP_View tables for a list directly from SQL Server. These tables
are updated every time a project is published.

--
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/