export multiple pivot tables with ExportBiff

[#1]

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.

[#2]

Hi,

Please follow the below thread for your problem solution:

http://community.qlik.com/message/1681#1681

Cheers.

[#3]

Can also have a look at http://community.qlik.com/message/4541#4541