topic Re: How to auto exporting pivot table to excel without clicking the button on HTML? in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-auto-exporting-pivot-table-to-excel-without-clicking-the/m-p/217292#M16347 <HTML><HEAD></HEAD><BODY><P>Check out <A __default_attr="163838" __jive_macro_name="user" class="jive_macro jive_macro_user" data-objecttype="3" href="https://communities.sas.com/"></A>'s recent article about this:</P><P></P><P><A href="http://blogs.sas.com/content/sgf/2015/03/27/using-sas-to-add-pivottables-to-your-excel-workbook/" title="http://blogs.sas.com/content/sgf/2015/03/27/using-sas-to-add-pivottables-to-your-excel-workbook/">http://blogs.sas.com/content/sgf/2015/03/27/using-sas-to-add-pivottables-to-your-excel-workbook/</A></P><P></P><P>Chris</P></BODY></HTML> Tue, 07 Apr 2015 16:38:13 GMT ChrisHemedinger 2015-04-07T16:38:13Z How to auto exporting pivot table to excel without clicking the button on HTML? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-auto-exporting-pivot-table-to-excel-without-clicking-the/m-p/217291#M16346 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to auto export the pivot table and creating a new excel file at the same time, but do not use the step of HTML. </P><P></P><P>Is there a way to realize it? Could you provide a sample code ? Thank you. <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Tue, 07 Apr 2015 15:55:07 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-auto-exporting-pivot-table-to-excel-without-clicking-the/m-p/217291#M16346 AmberLOL 2015-04-07T15:55:07Z Re: How to auto exporting pivot table to excel without clicking the button on HTML? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-auto-exporting-pivot-table-to-excel-without-clicking-the/m-p/217292#M16347 <HTML><HEAD></HEAD><BODY><P>Check out <A __default_attr="163838" __jive_macro_name="user" class="jive_macro jive_macro_user" data-objecttype="3" href="https://communities.sas.com/"></A>'s recent article about this:</P><P></P><P><A href="http://blogs.sas.com/content/sgf/2015/03/27/using-sas-to-add-pivottables-to-your-excel-workbook/" title="http://blogs.sas.com/content/sgf/2015/03/27/using-sas-to-add-pivottables-to-your-excel-workbook/">http://blogs.sas.com/content/sgf/2015/03/27/using-sas-to-add-pivottables-to-your-excel-workbook/</A></P><P></P><P>Chris</P></BODY></HTML> Tue, 07 Apr 2015 16:38:13 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-auto-exporting-pivot-table-to-excel-without-clicking-the/m-p/217292#M16347 ChrisHemedinger 2015-04-07T16:38:13Z