creating a list of customized fields in VBA

M

Mark VII

I just inherited a project plan, that has a variety of field customizations.
Would like to have a list of the customized fields, values lists, etc.
Instead of going to Tools, Customize, Fields and compiling a list of
customizations via manual brute force, I'd like to extract this
programatically.

What I'm not finding is a collection or collections that I can loop through
to output the customizations. I found methods for renaming a field and
setting its value list (CustomFieldRename and CustFieldValueListAdd), but
have struck out so far on how to read through and output the customizations.

Any suggestions?
TIA....
 
J

John

Mark VII said:
I just inherited a project plan, that has a variety of field customizations.
Would like to have a list of the customized fields, values lists, etc.
Instead of going to Tools, Customize, Fields and compiling a list of
customizations via manual brute force, I'd like to extract this
programatically.

What I'm not finding is a collection or collections that I can loop through
to output the customizations. I found methods for renaming a field and
setting its value list (CustomFieldRename and CustFieldValueListAdd), but
have struck out so far on how to read through and output the customizations.

Any suggestions?
TIA....
Click to expand...

Mark,
Well if you are looking in the Object Browser, you are looking in the
right place. I found two things that might help.
CustomFieldGetName Method
CostomFieldValueListGetItem Method

With the first, I would loop through all the PjCustomField values. With
the second, I would set up a loop and increment until an error occurs.
Use the On Error Resume Next to "gracefully" exit the loop.

Hope this helps.
John
Project MVP
 
Top