Microsoft Excel Training Videos

Creating a macro in Microsoft Excel to open a workbook

Opening a Workbook in Excel
When you open a workbook using the Open method in Microsoft Excel, it becomes a member of the Workbooks collection. The following procedure in Excel opens a workbook named MyBook.xls located in the folder named MyWorkBooks on drive D.
Sub OpenUp()
Workbooks.Open("D:\MyWorkBooks\MyBook.xls")
End Sub
The Excel training video takes you through all the steps involved in writing and executing the macro.



Further reading

Open Method [Excel 2003 VBA Language Reference]

Opening a Workbook in Excel using VBA