How to: 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 application-level projects for Excel 2013 and Excel 2010. 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.
Me.Application.Workbooks.Open("C:\Test\YourWorkbook.xlsx")this.Application.Workbooks.Open(@"C:\Test\YourWorkbook.xlsx");
Compiling the Code
This code example requires the following:
- A workbook named YourWorkbook.xls must exist in a directory named Test on drive C.
See Also
Tasks
How to: Programmatically Open Text Files as Workbooks
How to: Programmatically Create New Workbooks
How to: Programmatically Save Workbooks
How to: Programmatically Close Workbooks
Concepts
Programmatic Limitations of Host Items and Host Controls