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
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.
Sub UseOpenXML()
Application.Workbooks.OpenXML _
Filename:="customers.xml", _
LoadOption:=xlXmlLoadImportToList
End Sub