Muktiple workbooks inExcel 2010 save as XML file

[jimbo45]

Multiple workbooks in Excel 2010 to be saved as an XML file

Hi all

It seems not possible to save a 2010 EXCEL spreadsheet containing multiple workbooks as an XML file -- however you CAN save it as a type 2003 XMLworkbook. This works and seems to conform to the XML standard but are MS going to drop this.

XML is a decent OPEN common standard -- we use it a lot for transferring data between various systems including SAP which although has its own IDOC type of interface it also handles XML files.

(Any SAP consultants -- XML also used a lot in XI / PI data transfer too --much better than IDOCS since you avoid another whole set of conversion processes and the XI / PI data can be formatted any way you want too).

I'm perplexed in that EXCEL 2010 is prompting for a format that is AT LEAST 2 releases of EXCEL earlier.

Are we suddenly going to lose XML support.

Showstopper if this DOES happen.

Cheers
jimbo

 

[Irene]

I am not altogether familiar with this subject, but I wondered if the following links might of some use:

Welcome to the Open XML SDK 2.0 for Microsoft Office

Merging Data from Multiple Workbooks into a Summary Workbook in Excel 2010