Referencing the file path location of another file

[scanavan]

Good morning,

In support of the indirect function, does anyone know of a function that can identify the file path location of another workbook.

This reference should return in the form of text (looking familiar to a hyperlink) which would then form an input into the indirect function.

Thank you

 

[BrianB]

Not sure what you mean. Where, in fact, is the 'other workbook' located ?
What 'other workbook' ?

 

[PATSYS]

=cell("Filename",Other workbook)

 

[scanavan]

Thank you

 

[scanavan]

Thank you

 

[scanavan]

Thank you