ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel 2007 XML Export (https://www.excelbanter.com/excel-worksheet-functions/236432-excel-2007-xml-export.html)

biz7

Excel 2007 XML Export
 
Hello,

Our bank just installed Microsoft Excel 2007. When I click on the Developer
tab in the Ribbon section & export, the file exports successfully. However,
I cannot import the file into my work application directly, "unless", I open
the file with notepad & delete the 1st line item which automatically is there
when I export from Excel 2007. The line item reads as follows: <?xml
version="1.0" encoding="UTF-8" standalone="yes"?

Is there a way to remove this automatic line item from the xml? I am not
sure what is causing the xml export to add this line item automatically.
Otherwise, I would be able to skip a step (do not open notepad) & just import
the xml file. Please advise-thanks for your assistance!


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

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