Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
export of data from SAP to MS-Excel 2007 Darshan Excel Discussion (Misc queries) 2 January 22nd 09 02:53 PM
Export Library from WMP 11 to Excel 2007 Dennis Excel Discussion (Misc queries) 0 February 3rd 08 08:18 PM
Excel 2007 export as XML size limit/bug Erik C. Nielsen Excel Discussion (Misc queries) 0 December 26th 07 07:09 PM
export data from sap to excel 2007 jain_sanju Excel Discussion (Misc queries) 0 December 17th 07 05:38 AM
Excel 2007 export file size huge Andy Payne Excel Discussion (Misc queries) 1 March 17th 07 11:08 PM


All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"