03-19-2015 04:18 PM
Upon output of a file using the syntax below:
ods msoffice2k file='\\SharePoint\filename.xls' style=mytheme;
and then accessing via a link in an email message, users always see the message in the attached capture.png.
How can this message be avoided / eliminated?
03-19-2015 04:49 PM
Specify the correct type with your attachment. Your xls file is not a xls file but an xml file that Excel can process.
http://support.sas.com/resources/papers/proceedings13/340-2013.pdf (content type adjustment attachments)
03-23-2015 02:11 PM
Can you use ods tagsets.excelxp? I think that msoffice2k tagset outputs an html\htm file, but that will open in like chrome or explorer by default. I'm guessing.
03-23-2015 09:38 PM
ODS MSOFFICE2K creates an HTML file (not an XML file). So the MSOFFICE2K FILE= option should have an extension of .HTM or .HTML.
03-24-2015 03:27 PM
Thanks Cynthia, but with htm or html, the file opens in a browser.
I do want it to open in Excel, preferably without the message. Since I'm filling the Excel file with proc tabulate output, ods would seem to be the easiest (or only?) option. Users will just have to put up with the warning message.
03-24-2015 04:07 PM
Indeed, you are correct. Unfortunately, it does not like the ods "style" that I've applied. Users will just have to put up with the warning message.
03-23-2015 11:50 AM
Like others mentioned, your output is really .XML, if you change the extension to that you'll not get the error. You can also turn off the error by changing extensionhardening in the windows registry, but that's tough to implement enterprise wide.