The function you'd want to use is =indirect().
But =indirect() won't work if the sending file is closed.
Laurent Longre has an addin (morefunc.xll) at:
That includes =indirect.ext() that may help you.
If you have trouble getting to the site, then search google for indirect.ext.
I found this alternative site:
I didn't look to see if it was the most current version.
I'd check the original site every so often to see if it's working.
On 09/23/2010 06:47, Frank wrote:
> In order to simplify the maintenance of workbook formulas I need to
> reference workbook name in hyperlink formula
> in this way
> given the file name stored in cell A1
> Cell A1 : myWorkbook
> How do I write the formula to make it work?
> Will it work even if the referenced workbook is closed?
> Frank Krogh