Forum Discussion
TulioOliveira
Dec 18, 2024Copper Contributor
Extract Data with VBA in the Project
Hi guys, I need some help.I need to extract data from the project to connect to Power BI. I'm currently using the feature in the database model by going to Report>Visual Report>Save Data Select: Task...
Ignacio_Martin
Dec 24, 2024Iron Contributor
Hi Tulio.
Custom fields in Ms Project are constant over time, they always have the same unique value assigned throughout the project for the task or resource, so you don't need to granulate anything.
If what you need is to export those 7 custom fields, you just need to include them in the task table columns and copy and paste into Excel, or if you prefer you can do an export to Excel via Save As with the xls file type, which are almost immediate procedures.
Only if you need to manage cost field information or resource work hours in different periods, the granular data you refer to makes sense, but not for custom fields, or any other type, other than cost or work, except for some fairly rare small exceptions.
Ignacio