topic Re: How can we export the multiple charts to excel with an single click in QlikView https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469632#M175397 <HTML><HEAD></HEAD><BODY><P>Hi Vibav,</P><P></P><P>&nbsp;&nbsp; Thanks for your reply.</P><P></P><P>&nbsp;&nbsp; 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.</P><P></P><P>&nbsp;&nbsp;&nbsp; At any chance you have like that macro.Please share me</P><P>Regards,</P><P>Santhosh</P></BODY></HTML> Fri, 05 Oct 2012 09:36:16 GMT 2012-10-05T09:36:16Z How can we export the multiple charts to excel with an single click https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469628#M175393 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I am having the query to export the excel multiple charts with an single click or post reload.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have prepared one macro.But its not exporting more than Four Charts. Its adding the multiple sheets but its not exporting after 4Charts.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Please find the attached same,</P><P></P><P></P><P>Thanks &amp; Regards,</P><P>Santhosh G</P></BODY></HTML> Fri, 05 Oct 2012 07:16:44 GMT https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469628#M175393 2012-10-05T07:16:44Z Re: How can we export the multiple charts to excel with an single click https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469629#M175394 <HTML><HEAD></HEAD><BODY><P>u nid 2 add in ur macro ALL the charts name u want to export....</P></BODY></HTML> Fri, 05 Oct 2012 07:37:37 GMT https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469629#M175394 Anonymous 2012-10-05T07:37:37Z Re: How can we export the multiple charts to excel with an single click https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469630#M175395 <HTML><HEAD></HEAD><BODY><P>Hi Vibav,</P><P></P><P>&nbsp;&nbsp; Thanks for suggesation.</P><P>&nbsp;&nbsp; If u seen my attachement the same thing i have did.But its not working fine.</P></BODY></HTML> Fri, 05 Oct 2012 08:00:43 GMT https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469630#M175395 2012-10-05T08:00:43Z Re: How can we export the multiple charts to excel with an single click https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469631#M175396 <HTML><HEAD></HEAD><BODY><P>hi santhoshgondrala</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; chk diz macro</P><P></P><P></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>SUB ExportExcel<BR /><BR /><BR /><BR />SET chart = ActiveDocument.GetSheetObject("CH01")<BR /><BR />SET chart1 =&nbsp; ActiveDocument.GetSheetObject("CH02")<BR /><BR /><BR /><BR />SET p = chart.GetProperties<BR /><BR />SET p1= chart.GetProperties<BR /><BR /> <BR /><BR /><BR /><BR /><BR /><BR />chart.SendToExcel<BR /><BR />chart1.SendToExcel<BR /><BR /><BR /><BR />END SUB </P><P></P></BODY></HTML> Fri, 05 Oct 2012 09:04:14 GMT https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469631#M175396 Anonymous 2012-10-05T09:04:14Z Re: How can we export the multiple charts to excel with an single click https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469632#M175397 <HTML><HEAD></HEAD><BODY><P>Hi Vibav,</P><P></P><P>&nbsp;&nbsp; Thanks for your reply.</P><P></P><P>&nbsp;&nbsp; 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.</P><P></P><P>&nbsp;&nbsp;&nbsp; At any chance you have like that macro.Please share me</P><P>Regards,</P><P>Santhosh</P></BODY></HTML> Fri, 05 Oct 2012 09:36:16 GMT https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469632#M175397 2012-10-05T09:36:16Z Re: How can we export the multiple charts to excel with an single click https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469633#M175398 <HTML><HEAD></HEAD><BODY><P>chk diz</P><P></P><P><A class="jive-link-external-small loading" href="http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/">http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/</A></P><P></P><P></P><P>regards,</P><P>vaibhav</P></BODY></HTML> Fri, 05 Oct 2012 10:02:52 GMT https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469633#M175398 Anonymous 2012-10-05T10:02:52Z Re: How can we export the multiple charts to excel with an single click https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469634#M175399 <HTML><HEAD></HEAD><BODY><P>Thank you very much</P></BODY></HTML> Fri, 05 Oct 2012 11:04:42 GMT https://community.qlik.com/t5/QlikView/How-can-we-export-the-multiple-charts-to-excel-with-an-single/m-p/469634#M175399 2012-10-05T11:04:42Z