No, that won't work.

See my post for the correct syntax.

--
regards,
Tom Ogilvy

Seth wrote in message
...
You are getting the error because you are not specifying
the file path. This will work:

Workbooks("C:\My Documents\Functions.xls").Open

Of course, I have no idea where the "Functions.xls" has
been saved - replace with the proper directory.

Seth

-----Original Message-----
I am trying to open a closed workbook using VBA code. I
used this code:

Workbooks("Functions.xls").Open

In the "ThisWorkbook" Object using a Workbook_Open ()
and
got a "Subscript out of range" error.


.