topic Surpass the Excel prompts, with usage of Tagsets.ExcelXP in ODS and Base Reporting

Surpass the Excel prompts, with usage of Tagsets.ExcelXP

pawan — Wed, 25 Sep 2013 16:24:25 GMT

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.

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Reeza — Wed, 25 Sep 2013 16:28:21 GMT

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.

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Cynthia_sas — Wed, 25 Sep 2013 16:29:15 GMT

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

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

pawan — Fri, 27 Sep 2013 09:01:44 GMT

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.

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

pawan — Fri, 27 Sep 2013 09:02:27 GMT

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

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Cynthia_sas — Fri, 27 Sep 2013 17:48:23 GMT

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

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

pawan — Fri, 11 Oct 2013 08:33:16 GMT

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

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

morglum — Fri, 13 Nov 2015 13:55:20 GMT

This link is dead, what did it say?

thanks

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

Cynthia_sas — Fri, 13 Nov 2015 22:43:17 GMT

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

cynthia

Re: Surpass the Excel prompts, with usage of Tagsets.ExcelXP

morglum — Wed, 02 Dec 2015 14:23:04 GMT

that's great- thanks!