L
Lina
Hello,
I have a query which i show in PivotTable View. I would like to use a
macro to export the pivot into an excel file on one tab and the data
behind it on another tab. If I press "Export to Excel" button from the
PivotTable View, it works correctly. But i have not been able to make
this work using a macro.
I have tried "Output To" and "TransferSpreadsheet" Commands but both
export the query data and not the Pivot view
Can anyone help?
I have a query which i show in PivotTable View. I would like to use a
macro to export the pivot into an excel file on one tab and the data
behind it on another tab. If I press "Export to Excel" button from the
PivotTable View, it works correctly. But i have not been able to make
this work using a macro.
I have tried "Output To" and "TransferSpreadsheet" Commands but both
export the query data and not the Pivot view
Can anyone help?