Workbooks.OpenXML Method
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 |
|---|
|