How to: Open XML Files as Workbooks

Applies to

The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.

Project type

  • Document-level projects

  • Application-level projects

Microsoft Office version

  • Excel 2003

  • Excel 2007

For more information, see Features Available by Application and Project Type.

This example demonstrates how you can use the OpenXML(String, Object, Object) method to open an XML file as a workbook.

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

The Variable missing and Optional Parameters in Office Solutions