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()
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