Mr Philips,
I downloaded and then tried the tool you suggested, without any luck.
I am wondeing, as it excel regularly works when I select name cell in an
open workbook, and it functions later if the data is changed, even when the
reference work book is closed. I can get the function to work I just cannot
auto build the function.
The character string in the cell looks Identical...
could it be somekind of formatting thing?
thanks,Stephen
"Bob Phillips" wrote:
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.