Workbooks.OpenXML method (Excel)

Opens an XML data file. Returns a Workbook object.


expression.OpenXML (FileName, Stylesheets, LoadOption)

expression A variable that represents a Workbooks object.


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



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", _ 
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.