I have re-created some web queries so that Excel spreadsheets that result from the queries are created using XML rather than POI. I have the spitting image of the POI output except for a minor detail. When the spreadsheet is opened and the user decides to save it using "File: Save As", the default file type for the "Save As" is XML. The user would like the default to be XLS. Is there a way to change the default file type to XLS via the XML code?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel XML save file question
- Thread starter Klutch
- Start date
My guess is that this is a result of the type of file that was opened; the default is to save as the same type of file.
Given the extensive capabilities of VBA, perhaps you should ask in forum707.
Tom Morrison
Given the extensive capabilities of VBA, perhaps you should ask in forum707.
Tom Morrison
- Thread starter
- #3
Unfortunately or fortunately, depending how one looks at things, the XML is being created using Java. If there is some way to code VBA for the spreadsheets, it would have to be through XML. Perhaps there is a way to do so. I will take your advice under consideration.
If you are using SpreadsheetML, then it might be that you can place something in the PresentationFormat element of DocumentProperties element.
Tom Morrison
Tom Morrison
- Status