Export (0) Print
Expand All

Workbooks.OpenXML Method (Excel)

Opens an XML data file. Returns a Workbook object.

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

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.

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
Show:
© 2014 Microsoft