XmlMaps Property

You use the XmlMaps property of the Workbook object to return an XmlMaps collection. Returns an XmlMaps collection. Read-only.

expression .XmlMaps

expression    Required. An expression that returns a Workbook object.

Remarks

The XmlMaps object is a collection of all of the XmlMap objects associated with a Spreadsheet component. An XmlMap is an XML schema map that specifies how to map data from a data source in the Spreadsheet component.

You can create a new XmlMap object by using the Add method of the XmlMaps collection. The XmlMap object is also available when you set the XmlUrl property of a Spreadsheet component to the name of an XML Spreadsheet file, or a string containing properly configured XML data, that contains the binding and mapping configuration for the Spreadsheet component. You can create an XML Spreadsheet file by creating a databound spreadsheet using Microsoft Excel and then saving the workbook as an XML Spreadsheet.

Example

The following example illustrates how to use the XmlMaps property of the WorkBook object to return an XmlMaps collection.

    Dim objMaps
Dim objMap
Dim strMapInfo

Set objMaps = Spreadsheet1.ActiveWorkbook.XmlMaps

For Each objMap in objMaps
     ' Save the XML map information to a variable.     
     strMapInfo = objMap.MapData
     ' Work with map information here.
Next