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


--
HTH
Roger
Shaftesbury (UK)



"Francis Cheung" wrote in message
...
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.