XmlMaps Collection

Microsoft Excel Visual Basic

XmlMaps Collection

Workbook XmlMaps
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