User Profile
TulioOliveira
Copper Contributor
Joined 18 days ago
User Widgets
Recent Discussions
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 SummaryField Picker (for custom fields) Save Database However, the chronogram is too large and I'm getting an error on this screen asking me to reduce/separate the project. I wanted to do this export in VBA, I even tried using the VBA code below, but I couldn't find a parameter to export the custom fields. Sub Macro1() VisualReportsSaveDatabase strNamePath:="C:\Users\tulio.oliveira\Downloads\Chronogram_Consolidated_V5.mdb", PjVisualReportsDataLevel:=pjLevelWeeks End Sub
