That's my task:
I have Excel files build with HTML content having the file extension .xls
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:
2. Set "save as" file extension depend on file
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.
can I set the default "save as" file extension for html content to .xlsx?
Thank you very much!