VBA Code

XPath Object

Use this object to get or set the data binding used by a list column or range.

Range.XPath.XMLMap
Range.XPath.SetValue
Range.XPath.Clear

ListColumn.XPath

Saving as XML

ThisWorkbook.SaveAs( , xlXMLSpreadsheet) 

Excel 2003 XML Format

Neither VBA code nor embedded objects or charts can be strored in the XMl files in Excel 2002 or 2003

'openxmldeveloper.com

Creating workbooks on the fly

Workbook.XMLMaps.Add 
Workbook.XMLMaps.Namespaces 
Workbook.XMLMaps().Delete 
Workbook.XMLMaps().Import 
Workbook.XMLMaps().Export 

Workbook.XMLMaps().DataBinding. 
Workbook.XMLMaps().Schemas(1) 

ActiveWorkbook.XmlImport ??