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.

Custom Search

Further reading
Open Method [Excel 2003 VBA Language Reference]
Microsoft Excel Training Videos