XMLURL Property
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Returns or sets a String representing the URL to an Extensible Markup Language (XML) file. Setting this property discards the currently-open workbook and loads the specified XML file into a new workbook. Read/write.
expression.XMLURL
expression Required. An expression that returns a Spreadsheet object.
Example
This example loads the contents of the specified XML file into Sheet1 of Spreadsheet1.
Spreadsheet1.XMLURL = "http://example.microsoft.com/Test.xml"