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.
... View more