That's my task:
I have Excel files build with HTML content having the file extension .xls
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
For older Excel versions the file will be opened as a "normal" Excel document.
Since Excel 2007 there are two problems I have to find a solution for:
1. Stop the startup extension warning because the file content doesn't match the extension.
I solved this problem with a registry entry that stops the extension check (see: http://blogs.msdn.com/b/vsofficedeve...n-warning.aspx)
2. Set "save as" file extension depend on file content type
When the user changes the document (the document with the html content) and selects "save as" in the file type dropdown "html" is selected.
This selection depends on the file content (I tried it with xml. In this case "xml" is selected).
But the user always want to save the file as .xlsx so it's a useless work to change the type every time.
-> How can I set the default "save as" file extension for html content to .xlsx?
Thank you very much!
Bookmarks