Forum Discussion
Sylvie_in_France
Jan 05, 2023Brass Contributor
Power Pivot, measures, VBA - ModelMeasure class
Hi everybody,
I've been faced too many times with issues when I modify a query loaded into the Data Model. Sometimes it's really impossible to recover. The only solution is to copy-paste all the queries in another workbook and rebuild the measures and pivot tables.
To simplify that task, I've developed a set of macros to export and import the measures with the associated format. If anyone is interested, I can share them.
I use the classes Model, ModelMeasures, ModelMeasure, ModelTable, etc.
Two points are not solved:
- The ModelMeasure.Description property doesn't work, neither read nor write
- The DecimalPlaces of the FormatInformation object can be retrieved but can't be set
Someone has managed to use those properties?
Thanks
No RepliesBe the first to reply