Export Single object to single sheet of same excel

[Kushal_Chawda]

Dear All,

I have 3 straight tables. I need to export these 3 charts in single excel file but in different sheet.

For eg. chart 1 should export in sheet 1 (Sheet name should take caption of chart)

chart 2 should export in sheet 2  & chart 3 should export in sheet 3

I am searching the macro for this but unable to find the macro.

Any help would be greatly appreciated.

Thanks in advance.

Regards,

Kush

[Gysbert_Wassenaar]

See this blog post (option 2) for a solution: http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

[Kushal_Chawda]

Thanks Gysbert,

can you please attach that application here..as I am not able to open tis website due to restrictions?

[Gysbert_Wassenaar]

See attached zip.

[Kushal_Chawda]

Thanks Gysbert

Using this macro I am not able to save the excel file.. what changes i need to do for the same..

Can you please help?

[suniljain]

Please allow macro execution on qlikview server.