Normally you would indirect the concatenated test to get the cell value, but
that won't work for closed workbooks, so take a look at
As for alternatives, try the INDIRECT.EXT function in Laurent Longre's
MOREFUNC.XLL add-in, available from
http://xcell05.free.fr/english/
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"sbardon" wrote in message
...
Hi, I hope you can help....
If I go through the long process and select
='C:\Documents and Settings\me\My
Documents\BNS\BNS20060002.xls'!Invoice_date
it will return the value of the cell
but....
when B11= 'C:\Documents and Settings\me\My Documents\BNS\
when A27= BNS20060002
When B20= Invoice_date
I write
=CONCATENATE(B11,A27,"xls'!",B20)
It creates
='C:\Documents and Settings\me\My
Documents\BNS\BNS20060002.xls'!Invoice_date
seemingly as text, how do I get it to be a cell reference?
I need to build this reference automatically.