When you open a workbook using the method, it becomes a member of the 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

See also: