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