how to export Multiple line charts in same sheet in excel in qlikview

[#1]

how to export Multiple line charts in same sheet in excel in qlikview?

I have 19-20 line chart in single tab in qlikview document.

I used a macro for pasting the charts in excel sheet on single tab.

The macro paste the line chart but unable to calculate the range because of this all the charts are pasted one above another.

Please assist me in this.

[Gysbert_Wassenaar]

See this blogpost

[#3]

i saw this there is hard coding is there for sheet range..

[#4]

Hi

Please find the URL

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

Hope this ref will work.

Regards-Bika