Surpass the Excel prompts, with usage of Tagsets.ExcelXP

[pawan]

lAs I divert my outputs to XML files, I get a prompt (window named as File Download) whether to Open or Save or Cancel, which I really dont want to have.

Is there any option like NoPrompt or open_excel="no"? I'm using sheet_name=" " option as I got to load data into multiple tabs, dont know if this option is causing me all the trouble

Below is sample code

ODS TAGSETS.EXCELXP FILE ="C:\.....\FILENAME.XML";

TITLE        " Title for 1st sheet";

ODS TAGSETS.EXCELXP OPTIONS(SHEET_NAME="SUMMARY" EMBEDDED_TITLES="yes" ABSOLUTE_COLUMN_WIDTH='10,15,8,....');

   Proc Steps....

TITLE        "  ";

TITLE        " Title for 2nd sheet";

ODS TAGSETS.EXCELXP OPTIONS(SHEET_NAME="DATA" EMBEDDED_TITLES="yes" ABSOLUTE_COLUMN_WIDTH='10,15,8,....');

   Proc Steps....

TITLE        "  ";

ODS _ALL_ CLOSE;

I appreciate all valuable suggestions. Thanks in advance.

[Reeza]

If you go into SAS Menu Tools>Options>Preferences

Then on the results tab make sure the view results as they are generated is not selected.

[pawan]

Thanks Reeza, Although this worked for me as of now, for some reasons the settings are not carried out for newer sessions. Also, now I'm worried of how it works with batch runs... may be I should look out for some options statement where I can have a complete control on this... Thanks once again.

[Cynthia_sas]

Hi:

  I'm not at a place where I can search for Tech Support notes, but I believe there is a Tech Support note about this prompt. There is no suboption that I know of to suppress this prompt.

cynthia

[pawan]

Thanks Cynthia, let me reach out to Support team..

[Cynthia_sas · Accepted solution]

Hi:

  I found it:

http://support.sas.com/kb/9/627.html

  Although this note references RTF and PDF specifically, I believe the fix is the same for any kind of external file (like the .XML file that you create with TAGSETS.EXCELXP) -- generally all of these files are opened with "3rd party" applications and this popup window is part of Windows behavior. You should NOT run into this issue in batch mode. You can verify with Tech Support, but I believe your only choice is the Windows Registry change.

cynthia

[pawan]

Thanks very much Cynthia, this really helps and I think this should be the ultimate resolution for any such requirements. Great!!

[morglum]

This link is dead,  what did it say?

thanks

[Cynthia_sas]

Sorry, looks like the Notes got restructured:
http://support.sas.com/techsup/notes/v8/9/627.html

cynthia

[morglum]

that's great- thanks!