XlXmlLoadOption enumeration (Excel)
Specifies how Excel opens the XML data file.
| Name | Value | Description |
|---|---|---|
| xlXmlLoadImportToList | 2 | Places the contents of the XML data file in an XML table. |
| xlXmlLoadMapXml | 3 | Displays the schema of the XML data file in the XML Structure task pane. |
| xlXmlLoadOpenXml | 1 | Opens the XML data file. The contents of the file will be flattened. |
| xlXmlLoadPromptUser | 0 | Prompts the user to choose how to open the file. |
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.