Workbooks.OpenXML method (Excel)
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
Example
The following code opens the XML data file Customers.xml and displays the file's contents in an XML list.
Sub UseOpenXML()
Application.Workbooks.OpenXML _
Filename:="Customers.xml", _
LoadOption:=xlXmlLoadImportToList
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.