XmlDataBindings Property

You use the XmlDataBindings property to return an XmlDataBindings collection. Read-only XmlDataBindings collection.

expression .XmlDataBindings

expression    Required. An expression that returns a Workbook object.

Remarks

The XmlDataBindings collection contains one or more XmlDataBinding objects. Each XmlDataBinding object contains configuration data that binds the Spreadsheet component to a data retrieval service, a SOAP Web Service, an XML file, or another Spreadsheet component.

Example

The following example uses the XmlDataBindings property of the Workbook object to return a member of the XmlDataBindings collection and then work with the XML that represents the binding information:

    

Dim objBindings
Dim objBinding
Dim strBindingInfo

Set objBindings = Spreadsheet1.ActiveWorkbook.XmlDataBindings

For Each objBinding in objBindings
     ' Save the XML binding information to a variable.     
     strBindingInfo = objBinding.BindingData
     ' Work with binding information here.
Next