Export Container with Pivot Tables to Excel

[zaidiwaqas]

Hi,

I have created a container comprising of multiple pivot tables.

Now I want to export them to one single excel file with multiple worksheets. I understand that I have to write a macro for that but can someone share the code for that.

"CT07" is the container name

"CH74","CH75","CH76","CH77","CH78","CH79","CH80","CH81","CH82","CH83","CH84","CH85","CH86","CH87","CH88","CH89","CH90","CH91","CH92","CH93","CH94","CH95","CH96","CH97","CH98","CH99","CH100","CH101","CH102","CH103","CH104","CH105","CH106" are pivot tables within the container.

Thanks

[dplr-rn · Accepted solution]

find link below for a repository of useful macros

#36 maybe what you need.

https://community.qlik.com/t5/QlikView-Documents/Useful-Qlikview-Macros/ta-p/1494530