XMLDOM

See Also

Returns an instance of an XML document object for a specified document.

Note   The XMLDOM function requires MSXML3.0 to be installed on any machine that is running the Spreadsheet component. If MSXML3.0 is not installed, this function will return the #NAME? error value. MSXML3.0 is included in a typical installation of Office XP, or you can download it from MSDN Online. MSXML3.0 is not included when you install the Microsoft Office Web Components from the Web. The hyperlink in this topic goes to the Web. You can switch back to Help at any time.

Syntax

XMLDOM(url)

URL   is the address of the specified document.

Example

=XMLDOM("customers.xml").SelectSingleNode("//Customer/Phone").Text

In this example, XMLDOM returns a customer phone number from the xml file, customers.xml, which looks like this:

<Customer>
     Davolio
     <Phone>
         555-1212
     </Phone>
</Customer>