Workbooks.OpenXML Method

  • Article
Excel Developer Reference

Opens an XML data file. Returns a Workbook object.

Syntax

expression.OpenXML(Filename, Stylesheets, LoadOption)

expression   A variable that represents a Workbooks object.

Parameters

Name Required/Optional Data Type Description
Filename Required String The name of the file to open.
Stylesheets Optional Variant Either a single value or an array of values that specify which XSL Transformation (XSLT) stylesheet processing instructions to apply.
LoadOption Optional Variant Specifies how Excel opens the XML data file. Can be one of the XlXmlLoadOption constants.

Return Value
Workbook

Remarks

XlXmlLoadOption can be one of these XlXmlLoadOption constants.
xlXmlLoadImportToList Automatically creates an XML List and imports data into the list.
xlXmlLoadMapXml Loads the XML file into the XML Source task pane.
xlXmlLoadOpenXml Open XML files in the same way that Excel 2002 opens XML files (for backwards compatibility only).
xlXmlLoadPromptUser Prompts the user and lets them choose the Import method.

Example

The following code opens the XML data file "customers.xml" and displays the file's contents in an XML list.

Visual Basic for Applications 
  Sub UseOpenXML()
    Application.Workbooks.OpenXML _
        Filename:="customers.xml", _
        LoadOption:=xlXmlLoadImportToList
End Sub

See Also