Hi, Anyone knows how to eliminate the warning below without revising the sas program?      The file you are trying to open, Data.xls, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? As per research, the warning message is a user-notification function that was added to Excel 2007. I believe this is an added security from Microsoft. Since we just upgraded from Microsoft Office 2003 to 2007, it was only now that we encounter this warning message. It is very troublesome since most of the programs we have make use of ODS HTML to output .xls file. I am hoping there is other way or option in SAS that we can use to resolve this? Thanks in advance! ... View more

Hi, I have a few questions regarding options on tableeditor. I hope someone can help clarify. 1. How I can make the excel_save_file option work? It seems that there is no Excel file being saved everytime I export it to Excel. 2. Is there a way to apply the options directly to Excel so that I don't have to export it after the HTML has been generated? 3. If I need to export several tables to Excel, is there a way to assign different sheet name for each table exported without prompts involved? Below is a sample code I am testing:      ods tagsets.tableeditor file="D:\Output\exporttoexcel.html"           style=styles.mystyle           options(excel_zoom="90"                       excel_scale="90"                       excel_autofilter="yes"                       excel_frozen_headers="yes"                       excel_orientation="landscape"                       sheet_name="test"                       auto_format="color1"                       excel_save_file="D:\Output\exporttoexcel.xls"                       open_excel="yes"                     );      proc print data=sashelp.class noobs;      run;      proc print data=sashelp.shoes noobs;      run;      ods tagsets.tableeditor close; Appreciate your immediate response. Thanks! ... View more