https://community.qlik.com/t5/QlikView/Create-a-macro-with-button-to-export-multiple-charts-to-separate/m-p/1576531#M741551 <P>I am new to macros overall, but essentially I am trying to create a button that will run a macro that will export multiple charts (5 for this example) to 5 different worksheets in a single Excel file. In a perfect world I'd have the option to set a name for the file as I'll be doing this over and over and don't want it to save everything as the same file name.</P><P>So for an example I want to export charts&nbsp;CH653 and CH779 and CH800 and CH675 and CH678 (I'll stop there). I then want to have it rename the sheets to what I want (say "Chart 653" and "Chart779" and "Chart800" ...) and then AutoFit all the columns.</P><P>I have tried looking at multiple posts with lots of similarities, but I can't get the charts to get past a second sheet and then none of the columns are auto-sized.</P><P>Can anyone provide a script that will do this?</P><P>Other details that might be helpful include:</P><P>- Save location = "C:\Files\..."</P><P>- Charts all have variable #'s of rows depending on the selections/filters applied</P><P>- Do I need to specify each sheet as to column range or can you do a blanket column range of "A:BB" or something like that?</P> Wed, 25 Nov 2020 16:16:04 GMT dawgfather 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Create-a-macro-with-button-to-export-multiple-charts-to-separate/m-p/1576531#M741551 <P>I am new to macros overall, but essentially I am trying to create a button that will run a macro that will export multiple charts (5 for this example) to 5 different worksheets in a single Excel file. In a perfect world I'd have the option to set a name for the file as I'll be doing this over and over and don't want it to save everything as the same file name.</P><P>So for an example I want to export charts&nbsp;CH653 and CH779 and CH800 and CH675 and CH678 (I'll stop there). I then want to have it rename the sheets to what I want (say "Chart 653" and "Chart779" and "Chart800" ...) and then AutoFit all the columns.</P><P>I have tried looking at multiple posts with lots of similarities, but I can't get the charts to get past a second sheet and then none of the columns are auto-sized.</P><P>Can anyone provide a script that will do this?</P><P>Other details that might be helpful include:</P><P>- Save location = "C:\Files\..."</P><P>- Charts all have variable #'s of rows depending on the selections/filters applied</P><P>- Do I need to specify each sheet as to column range or can you do a blanket column range of "A:BB" or something like that?</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Create-a-macro-with-button-to-export-multiple-charts-to-separate/m-p/1576531#M741551 dawgfather 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Create-a-macro-with-button-to-export-multiple-charts-to-separate/m-p/1576541#M741552 i dont have 1 single answer for you. but did you check below link?<BR />it has a few different ones which you can combine the principles to achive what you need.<BR />from first look combination of #2, #36 and #38 might get you there.<BR /><BR />p.s. fyi your end users will need IE plug in for macros to work<BR /><BR /><A href="https://community.qlik.com/t5/QlikView-Documents/Useful-Qlikview-Macros/ta-p/1494530" target="_blank">https://community.qlik.com/t5/QlikView-Documents/Useful-Qlikview-Macros/ta-p/1494530</A> Fri, 03 May 2019 19:13:59 GMT https://community.qlik.com/t5/QlikView/Create-a-macro-with-button-to-export-multiple-charts-to-separate/m-p/1576541#M741552 dplr-rn 2019-05-03T19:13:59Z