Hello Sir,

I'm really looking for a way to get the full address of the external file by specifying the file name in a cell and then evaluate the formula. For example, 

='C:\Users\[Source.xlsx]Sheet1'!$F$1
is the full address of the source file called 'Source'. My idea is: if I just type the file name 'Source' in a workbook's cell $A$1, and in cell $B$1 I want to make the formula something like:

="C:\Users\["&$A$1&".xlsx]Sheet1'!$F$1"

This will make my project very impressive with this feature: a user just types the file name to establish the link and evaluate the formula for results.

Thanks in advance.