Linked File Names and Path
 

Suppose I have a file that is linked to multiple different Workbooks.

Suppose that Cell A1 on Sheet1 is linked to a particular workbook such as:

=+[SourceExample.xls]TestSheet$a$1

What I need to be able to do is get the full file name and path of the
SourceExample.xls sheet in this case.

I was previously capturing the file location in the source file and passing
it to the destination file, via a linked cell, however that requires the user
to update (on open and save) the source file everytime the file is moved.

Thanks in advance for any help.