XmlMaps Collection
XmlMap
Multiple objects
Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.
Represents the collection of XmlMap objects that have been added to a workbook.
Using the XmlMaps Collection
Use the Add method to add an XML map to a workbook.
Sub AddXmlMap()
Dim strSchemaLocation As String
strSchemaLocation = "http://example.microsoft.com/schemas/CustomerData.xsd"
ActiveWorkbook.XmlMaps.Add strSchemaLocation, "Root"
End Sub