another tagsets.excelxp question

[gusfryk01]

I like to use  tagsets.excelxp to export output to excel.

The problem is I can never export more than one table to the same file, even if I specify different sheets each time.

The file still gets overwritten.

Is there a solution?  

[Reeza · Accepted solution]

You're doing it wrong

See AND RUN the sample code under the home page, and they export multiple tables, see Data Driven Worksheets for an example.

Base SAS: Demo: ExcelXP Tagset and Microsoft Excel

You need to close the file AFTER you've finished all your "proc prints" or other procedures that you want outputted to the file.

You cannot append to an already created Tagsets.ExcelXP file.

[gusfryk01]

Thanks alot!

Gonna save me alot of time