read all ProjectCustomFields Values

[Manuel Schmitt]

Hello,

can someone tell me, how i can read all ProjectCustomField- Values for all Projects?

Greetings

EggHeadCafe - Software Developer Portal of Choice
Pragmatic ADO.NET
http://www.eggheadcafe.com/tutorial...-481a-ae64-fef7fa935d71/pragmatic-adonet.aspx

 

[Rod Gill]

I assume you mean with Project Server (because without there are only
Text1-30 etc)?

Read the field names at the end of Views ending with _Userview in the
reporting db using oledb.

Query: SELECT TOP 1 * FROM msp_projects_userview

dim rs as adodb.recordset
dim fld as adodb.field

rs.open SQL,Conn etc

for each fld in rs.fields
fld.name
next fld

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Hello,

can someone tell me, how i can read all ProjectCustomField- Values for all
Projects?

Greetings

EggHeadCafe - Software Developer Portal of Choice
Pragmatic ADO.NET
http://www.eggheadcafe.com/tutorial...-481a-ae64-fef7fa935d71/pragmatic-adonet.aspx

__________ Information from ESET Smart Security, version of virus
signature database 4525 (20091020) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4525 (20091020) __________

The message was checked by ESET Smart Security.

http://www.eset.com