Richard

Try....

Workbooks.Open ThisWorkBook.Path & "\XYZ.xls"

--
XL2002
Regards

William


"Richard" wrote in message
...
| I'm trying to determine whether or not this can be done using VBA:
|
| Using Windows Explorer, say, I double-click to open an Excel file
| located in a directory other than the default Excel directory. In this
| workbook is VBA code that attempts to open another workbook located in
| the same directory:
|
| Workbooks.Open "XYZ.xls"
|
| The operation fails, apparently because it's looking in the default
| Excel directory. Is there a way to specify that the program look in the
| current, working directory?
|
| Rich