Not really close. I don't just need the name of the file or tab. I need
the absolute reference between the two to remain even if tabs get renamed.
That posting talks about extracting values of linked files, which is great,
but I need to take it a step further in case a tab is renamed and the linked
sheet is not open to keep the link active until the tab in it can be
renamed.

Thanks!

"DM Unseen" wrote in message
oups.com...
Repost!

Use Workbook Named ranges, since they are independent of the worksheet.
they can be accesd externally

Use a custom INDIRECT function that allows external references:

VBA
version:http://groups-beta.google.com/group/...3f710fa81f755b

XLL version: http://xcell05.free.fr/

DM Unseen