VBA to copy pivottable

[David31101990]

Hi,

I'm looking for a VBA that can copy a PivotTable to my workbook. The PivotTable is at another location. When I open my workbook, this VBA must replace the old PivotTable by the most recent PivotTable. How do I do this with VBA? Thanks in advance!

David

 

[Trevor G]

David,

Look to record a macro and start by opening the workbook you want to copy the Pivot From then select the pivot and copy then close the workbook next look to delete your pivot and then paste the recorded one that will give you the code.