find whether the column is present or not in the resource sheet

[DKD]

Hi,
Am new to Project development and i need your help in solving the below issue.

How can we make sure whether the custom column is present or not using VBA?

For example, i want to check if the enterprise custom field exists in the
resource sheet.

Thank you in advance.

 

[Jan De Messemaeker]

Hi,

Just published a macro answering a similar question in the thread initiated
by Robert on 16/03/19 (How to list all the fields displayed in a project
table); with minor adaptation your question can be answered.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[DKD]

Sorry, i forgot to mention the following conditions in the previous post.

Actually i need to find the existence of the field name directly without
using the collection 'ActiveSelection.FieldNameList' using for loop.

This needs to be worked even if the custom fields are hidden in the view.

thank you again.

 

[Jan De Messemaeker]

Well, if you refuse the solution, you probably don't need it so badly

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Jan De Messemaeker]

Hi,

The solution I propose does not use activeselection, and it will also detect
fields in the table with a width of zero (if that is what you mean by
hidden)

Greetings,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf