Programmatically open workbooks

The Workbooks collection in Microsoft Office Excel makes it possible to work with all open workbooks and to open workbooks.

Applies to: The information in this topic applies to document-level projects and VSTO Add-in projects for Excel. For more information, see Features available by Office application and project type.

To open an existing workbook

Use the Open method of the Workbooks collection, passing in the path to the workbook.

this.Application.Workbooks.Open(@"C:\Test\YourWorkbook.xlsx");

Me.Application.Workbooks.Open("C:\Test\YourWorkbook.xlsx")

This code example requires the following:

A workbook named YourWorkbook.xls must exist in a directory named Test on drive C.

Training

Module

Learn how to use Power Automate for desktop to open, read, and manipulate Excel files with various Microsoft Excel actions.

Certification

Demonstrate that you have the skills needed to get the most out of Excel 2016 by earning a Microsoft Office Specialist (MOS) certification.