Opening a Workbook

See Also

When you open a workbook using the Open method, it becomes a member of the Workbooks collection. The following procedure opens a workbook named MyBook.xls located in the folder named "MyFolder" on drive C.

Sub OpenUp()
    Workbooks.Open("C:\MyFolder\MyBook.xls")
End Sub