I'm writing a template for users in my company that needs to pull reference
data from another workbook. I've figured out how to open that workbook
automatically (thanks for input from the VBA Programming section!).

The users will put the two workbooks into the same folder, but I don't know
in advance what workbook that will be.

I've used some workbook.open vba to open the other workbook automatically,
using 'THISWORKBOOK.PATH' to find and open it. I'm having trouble putting
'THISWORKBOOK.PATH' into the equation in this active workbook to find and
pull data from the reference workbook opened by vba.

How can I write the equation to pull reference data automatically from the
other workbook, regardless what folder the user places them in?

Thanks in advance.