topic Re: export to excel in QlikView https://community.qlik.com/t5/QlikView/export-to-excel/m-p/718348#M258144 <HTML><HEAD></HEAD><BODY><P>no I need to automate this </P><P>i know I can right-click and export to excel ; come on!!</P></BODY></HTML> Mon, 29 Sep 2014 11:30:00 GMT ali_hijazi 2014-09-29T11:30:00Z export to excel https://community.qlik.com/t5/QlikView/export-to-excel/m-p/718346#M258142 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>got 3 pivot tables</P><P>I want to export these into one excel workbook and each on a sheet in the excel</P><P>is there a macro that does this?</P><P>please advise</P></BODY></HTML> Mon, 29 Sep 2014 11:21:57 GMT https://community.qlik.com/t5/QlikView/export-to-excel/m-p/718346#M258142 ali_hijazi 2014-09-29T11:21:57Z Re: export to excel https://community.qlik.com/t5/QlikView/export-to-excel/m-p/718347#M258143 <HTML><HEAD></HEAD><BODY><P>in chart properties &gt; caption&gt;check the box export to xl</P></BODY></HTML> Mon, 29 Sep 2014 11:26:45 GMT https://community.qlik.com/t5/QlikView/export-to-excel/m-p/718347#M258143 Anonymous 2014-09-29T11:26:45Z Re: export to excel https://community.qlik.com/t5/QlikView/export-to-excel/m-p/718348#M258144 <HTML><HEAD></HEAD><BODY><P>no I need to automate this </P><P>i know I can right-click and export to excel ; come on!!</P></BODY></HTML> Mon, 29 Sep 2014 11:30:00 GMT https://community.qlik.com/t5/QlikView/export-to-excel/m-p/718348#M258144 ali_hijazi 2014-09-29T11:30:00Z Re: Re: export to excel https://community.qlik.com/t5/QlikView/export-to-excel/m-p/718349#M258145 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check if this helps.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 29 Sep 2014 12:27:21 GMT https://community.qlik.com/t5/QlikView/export-to-excel/m-p/718349#M258145 ashfaq_haseeb 2014-09-29T12:27:21Z Re: Re: export to excel https://community.qlik.com/t5/QlikView/export-to-excel/m-p/718350#M258146 <HTML><HEAD></HEAD><BODY><P>ok that's fine but I need to have always one excel file</P><P>will the SaveAs method simply overwrites existing excel file on every time the macro is ran?</P></BODY></HTML> Mon, 29 Sep 2014 14:35:58 GMT https://community.qlik.com/t5/QlikView/export-to-excel/m-p/718350#M258146 ali_hijazi 2014-09-29T14:35:58Z