The function you'd want to use that's built into excel is =indirect(). But that
function returns an error if the sending workbook is closed.
If that's a problem, then Laurent Longre has an addin (morefunc.xll) at:
http://xcell05.free.fr/
or
http://xcell05.free.fr/morefunc/english/index.htm
That includes =indirect.ext() that may help you.
Miree wrote:
Sorry, I removed the file path because it is very long - will this still work
to reference a full file path?
"Stefi" wrote:
In your example FILE is a SHEET name rather than a file name, isn'it? If so,
sheet name being in A1
=INDIRECT(A1&"!C4")
Regards,
Stefi
€˛Miree€¯ ezt Ć*rta:
I have this formula that works fine, is there a way to replace the file to
reference a cell, so that I can just change the file name in one cell rather
thn the many the formula appears in?
=IF(FILE'!$C4="","",'FILE'!$C4))
--
Dave Peterson