On May 19, 10:35*am, Amedee Van Gasse
wrote:

And yet another reason why I don't want to use Indirect to get the
book name: I don't trust Excel. I want to be 200% sure that it goes
looking in the correct directory for the workbooks. I think (correct
me if I'm wrong) that I can only do that if I use the full path, and
the only reliable method I know is in VBA. Sure, I could use the
INFO("directory") function, but if I'm well informed, the parameter
for the Info function is language dependent.

Another reason why INFO("directory") cannot be used: it gets the
current *application* directory. I don't want that, I want the current
*workbook* directory.