View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
biz7 biz7 is offline
external usenet poster
 
Posts: 5
Default 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!