How to: Open XML Files as Workbooks

This example demonstrates how you can use the OpenXML method to open an XML file as a workbook.

Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2007 and Excel 2010. For more information, see Features Available by Office Application and Project Type.

Example

Me.Application.Workbooks.OpenXML("C:\Test.xml")
this.Application.Workbooks.OpenXML(@"C:\Test.xml", missing, missing);

Compiling the Code

This example requires:

  • A valid XML file named Test.xml that is stored on drive C.

See Also

Tasks

How to: Open Text Files as Workbooks

How to: Open Workbooks

How to: Create New Workbooks

How to: Save Workbooks

How to: Close Workbooks

Concepts

Working with Workbooks

Optional Parameters in Office Solutions