Using VBA or Excel query to find out structure and contents of MS Project 2010 custom fields
Posted on 2014-07-18
We use custom fields in Microsoft Project 2010 extensively. We often get plan files from other people and it would be helpful if there was a way to produce a report or data table showing the settings for custom fields as well as any lookup tables or formulas they might contain.
I have typically been opening the custom fields dialog and using screen shots to capture images of the windows, but it's a very manual process. Does anyone know of a way to pull custom field settings and values out of a project plan file using a query or VBA script?