Share via

OpenXML Method [Excel 2003 VBA Language Reference]

  • Article

Note  XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

Opens an XML data file. Returns a Workbook object.

expression.OpenXML(Filename, Stylesheets, LoadOption)

expression Required. An expression that returns one of the objects in the Applies To list.

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.

XlXmlLoadOption

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.

Sub UseOpenXML()
    Application.Workbooks.OpenXML _
        Filename:="customers.xml", _
        LoadOption:=xlXmlLoadImportToList
End Sub

Applies to | Workbooks Collection