Save the layout of PivotTable

  • Thread starter Thread starter Francis Cheung
  • Start date Start date
F

Francis Cheung

Hi,
I am now programming with PivotTable in VB6 environment.
I would like to know is there any method to save the
layout of the PivotTable in OfficeXP? And how to load this
saved layout back to the PivotTable? The data source of
the PivotTable is OLAP cube.

Thanks a lot.
 
When I do this solely in Excel/VBA, I use the macro recorder, then edit the
code. Code for reproducing the PivotTable is then prefixed with
sheet(sheetname).delete
 
Back
Top