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. |
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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for