How can we export the multiple charts to excel with an single click

[#1]

Dear All,

      I am having the query to export the excel multiple charts with an single click or post reload.

      I have prepared multiple Charts like 40,i need to export those all reports at a one shot.Can please help me out on this.

       I have prepared one macro.But its not exporting more than Four Charts. Its adding the multiple sheets but its not exporting after 4Charts.

     Please find the attached same,

Thanks & Regards,

Santhosh G

[Anonymous]

u nid 2 add in ur macro ALL the charts name u want to export....

[#3]

Hi Vibav,

   Thanks for suggesation.

   If u seen my attachement the same thing i have did.But its not working fine.

[Anonymous]

hi santhoshgondrala

                         chk diz macro

SUB ExportExcel



SET chart = ActiveDocument.GetSheetObject("CH01")

SET chart1 =  ActiveDocument.GetSheetObject("CH02")



SET p = chart.GetProperties

SET p1= chart.GetProperties







chart.SendToExcel

chart1.SendToExcel



END SUB

[#5]

Hi Vibav,

   Thanks for your reply.

   This Macro is to export to different excels.But Client requirement is it should export into one excel in difeerent sheets an each sheet its should be one chart.

    At any chance you have like that macro.Please share me

Regards,

Santhosh

[Anonymous]

chk diz

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

regards,

vaibhav

[#7]

Thank you very much