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