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.