ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel xls to xml (https://www.excelbanter.com/excel-programming/356983-excel-xls-xml.html)

Vet

excel xls to xml
 
I want to convert an older xls file to xml. I can save it as that but it
doesn't display properly. What can I do?

[email protected]

excel xls to xml
 
Depending how much data there is in it, I would open it up, create a
new document in the latest format and then copy and paste from the old
to the new (or write a VBA proceedure if there was a lot of Sheets).
Once you have the data in the new spreadsheet, save it with a new name
then try to export as .XML
That should help clean it up and may solve your problem.



All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com