Prevent Tabs on Multiple Print Requests

[OS2Rules]

Hi All:

Just a quick question to same me hours and hours of searching...

Is there a way to prevent the EXCELXP tagset from generating a new tab for each PROC REPORT that I have?

I'm generating a number of reports after I open the sheet, but the user wants them one after the other, rather than on separate tabs.

Thanks in advance.

[Cynthia_sas]

Hi:
Run your job with the sub-option for doc:
[pre]
ods tagsets.excelxp file='xxxx.xml' options(doc='Help');
[/pre]

and then look for the SHEET_INTERVAL sub-option. I believe that you can control whether a new tab starts by using that sub-option.

In addition, if you want more control over printing of the ExcelXP spreadsheet from within Excel, this is a very useful paper:
http://www.nesug.org/proceedings/nesug08/ap/ap06.pdf

cynthia

[OS2Rules]

Cynthia:

Genius, as always.

Thanks.