T
Troubled User
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.
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.