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.
This example loads the contents of the specified XML file into Sheet1 of Spreadsheet1.
Spreadsheet1.XMLURL = "http://example.microsoft.com/Test.xml"