Hi !!
first sorry for my english.
I want to export multiple pivot tables with a macro.
Looking on the community ; i created a object as a Excel.Aplication and the i copy the pivot tables
using their ID and pasting in each sheet of the Excel...
But now i discover the function ExportBiff.
I am testing this function and discover that i export the pivot tables with the format of the pivot table.
But i have a problem.
How can i export multiple pivot tables in one excel??
Each pivot table in a a sheet.
Thanks for all.
