Lookup file with relative pathname

H

Hall

My formulas such as VLOOKUP refer to cells in other workbook files.

Excel automatically uses the "hardcoded" absolute pathnames to these files.
I need to use a relative pathname so that the set of workbooks are portable.

For example, where I currently have
vlookup(A1,'N:\Groupname\projectA\workbook.xls'!B1:B10,1)

I want
vlookup(A1,'..\workbook.xls'!B1:B10,1)

Is this possible?
 
H

Hall

I'm not aware of any such function or construct.

Ian said:
Can you use something like the Path property to retrieve the full path of
the current workbook then use this to construct the hard-coded pathname? I'm
not sure how to create the pathname within the vlookup argument, but this
may be a starting point for you.

eg fullpath = Workbooks("book1.xls").Path
Click to expand...
 
Top