DisplayXMLSourcePane Method

Microsoft Excel Visual Basic

DisplayXMLSourcePane Method

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.

Opens the XML Source task pane and displays the XML map specified by the XmlMap argument.

expression.DisplayXMLSourcePane(XmlMap)

expression    Required. An expression that returns an Application object.

XmlMap    Optional XmlMap object. The XML map to display in the task pane.

Remarks

You can use the following code to hide the XML Source task pane.

      Application.CommandBars("Task Pane").Visible = False
    

Example

The following example adds an XML map named Customers to the active workbook, and then displays the XML map in the XML Source task pane.

    Sub DisplayXMLMap()
    Dim objCustomer As XmlMap
    
    Set objCustomer = ActiveWorkbook.XmlMaps.Add( _
                      "Customers.xsd", "Root")

				objCustomer.Name = "Customers"
    
    Application.DisplayXMLSourcePane
				objCustomer
End Sub