topic Re: another tagsets.excelxp question in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/another-tagsets-excelxp-question/m-p/186809#M1582 <HTML><HEAD></HEAD><BODY><P>You're doing it wrong <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><P></P><P>See AND RUN the sample code under the home page, and they export multiple tables, see Data Driven Worksheets for an example.</P><P><A href="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html" title="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html">Base SAS: Demo: ExcelXP Tagset and Microsoft Excel</A></P><P></P><P>You need to close the file AFTER you've finished all your "proc prints" or other procedures that you want outputted to the file.</P><P></P><P>You cannot append to an already created Tagsets.ExcelXP file.</P></BODY></HTML> Tue, 25 Feb 2014 20:45:31 GMT Reeza 2014-02-25T20:45:31Z another tagsets.excelxp question https://communities.sas.com/t5/Microsoft-Integration-with-SAS/another-tagsets-excelxp-question/m-p/186808#M1581 <HTML><HEAD></HEAD><BODY><P> I like to use&nbsp; tagsets.excelxp to export output to excel.</P><P></P><P>The problem is I can never export more than one table to the same file, even if I specify different sheets each time.</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">The file still gets overwritten.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Is there a solution?&nbsp;&nbsp; </SPAN></P></BODY></HTML> Tue, 25 Feb 2014 20:23:01 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/another-tagsets-excelxp-question/m-p/186808#M1581 gusfryk01 2014-02-25T20:23:01Z Re: another tagsets.excelxp question https://communities.sas.com/t5/Microsoft-Integration-with-SAS/another-tagsets-excelxp-question/m-p/186809#M1582 <HTML><HEAD></HEAD><BODY><P>You're doing it wrong <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><P></P><P>See AND RUN the sample code under the home page, and they export multiple tables, see Data Driven Worksheets for an example.</P><P><A href="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html" title="http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html">Base SAS: Demo: ExcelXP Tagset and Microsoft Excel</A></P><P></P><P>You need to close the file AFTER you've finished all your "proc prints" or other procedures that you want outputted to the file.</P><P></P><P>You cannot append to an already created Tagsets.ExcelXP file.</P></BODY></HTML> Tue, 25 Feb 2014 20:45:31 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/another-tagsets-excelxp-question/m-p/186809#M1582 Reeza 2014-02-25T20:45:31Z Re: another tagsets.excelxp question https://communities.sas.com/t5/Microsoft-Integration-with-SAS/another-tagsets-excelxp-question/m-p/186810#M1583 <HTML><HEAD></HEAD><BODY><P>Thanks alot!</P><P></P><P>Gonna save me alot of time</P></BODY></HTML> Wed, 26 Feb 2014 13:27:25 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/another-tagsets-excelxp-question/m-p/186810#M1583 gusfryk01 2014-02-26T13:27:25Z