MS Project Valuelist

[zafbasha]

While using "Customize fields", is it possible to populate a valuelist
via code using an ODBC connection of some kind ratrher than manually
keying in the valuelist? If so, can someone point me in the right
direction, thanks.

Zaf

 

[JackD]

Sure with some VBA you can set the list to whatever you want.

To set the values you use the CustomFieldValueListAdd method.

CustomFieldValueListAdd FieldID:=pjCustomTaskText1, Value:="A",
Description:="Apple"
CustomFieldValueListAdd FieldID:=pjCustomTaskText1, Value:="B",
Description:="Bear"

Where you get the values for the value and description is up to your
imagination, Could be from a text file, database, excel spreadsheet ...

See my site for some examples of working with other file types (most
examples are writing, but reading is about the same)