I have also created a column with the relevant file name through a Vlookup function. So the question is - how can I replace the absolute file path with a relative file path?
Assumed I have the file name and path in Column D
=[FileA.xls]Sheet1!B1
with something like
=[(D1).xls]Sheet1!B1?