Loop All Projects

[Nadav]

hey Guys , how r u all ?
hope this is not going to be a challenge, cause it was supposed to be
trivial but...
i'm using project server 2003 and my task includes running over all the
projects that exist on the server (checked in +checked out) ...

the problem is that without using the PDS i can find no way to reach them ...
the "application.projects" point to all open projects only , and if u try
and go around with the fileSearch object , all u get is the projects saved
offline in "c:\ my documents" (default folder)...

does anyone know a simple way of doing so (VBA please)...

10x,
Nadav

 

[Ed Morrison]

Open a db connection to the Project Server database and do a select command
on the MSP_Projects table. ex. Select proj_name from msp_projects.