column / table in draft database that flags project object as atemplate

A

andy.novak

Anyone know of data I can check for this? I've got a VBA running
that scans through all the rows in MSP_Projects, opens the project,
sets the value of a custom field, saves, and checks in.

Problem is, a couple of templates are included in the list and the VBA
stops on the save because you have to give it a project name.

I want to skip these rows in the SQL statement.

Thanks
Andy Novak
UNT
 
R

Rod Gill

Hi Andy,

There should be a ProjectType field where 0 is normal project and 1 is
template. Note that in Project Server 2007 it is safer to use the tables or
Views in the Reporting db. I recommend the View MSP_EpmProject_Userview as
it automatically holds all custom fields as well.

--

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

column / table in draft database that flags project object as atemplate 2
Ways to perform a mass owner transfer and project rename? 4
Deleting a record from a record set? 3
Selecting multiple lines in a VBA listbox? 2
vba - how can i get the values in this column to sort according tothe hierarchy? 3
VBA code to automatically (or automagically) populate a project teamfrom the same resources each tim 7
Possible to delete the Workspace of a project ONLY for re-creationwith a new template? 1
Change owner of project with SQL? 1

Top