In Project Server 2007 look at the _User Views in the Reporting database.
There is one for Projects, Tasks, Resources and Assignments.
In Project Server 2003 read the pjsrvr.htm file and it tells you how. I
recommend reading the MSP_VIEW tables.
In VBA 2003 simply use the field name, EG
activeproject.Tasks(1).EnterpriseCost1
In 2007 it's a little more complex, use:
GetField(FieldNameToFieldConstant("Custom Field Name"))
--
Rod Gill
Project MVP
NEW!! Project VBA Book, for details visit:
http://www.projectvbabook.com