Buidling a string to ref cell in other book

  • Thread starter Thread starter brtwnl
  • Start date Start date
B

brtwnl

I can paste special a link to a cell in another file. It link
properly.

='Z:\Projects\CompanyName\Project 04-011\Cost Estimat
04-011.xls'!Total_Cost


When I try to build the string to refernece the cell, it simply print
the concatenated string, not the referenced value.

=CONCATENATE("'Z:\Projects\",C17,"\Project ",A17,"\Cost Estimat
",A17,".xls'!Total_Cost")

Result is just
'Z:\Projects\CompanyName\Project 04-011\Cost Estimat
04-011.xls'!Total_Cost

How do I get the value of the referenced cell after building
concatenated string?

Wayn
 
Hi
if you want to access a closed workbook (as it seems from your posting)
you
may have a look at the Add-In MOREFUNC.XLL
(http://longre.free.fr/english)
use the function INDIRECT.EXT.e.g.
=INDIRECT.EXT("'Z:\Projects\CompanyName\Project 04-011\[Cost Estimate
04-011.xls]'!Total_Cost")

For accessing an open workbook you may use the build-in function
INDIRECT. e.g.
=INDIRECT("'Cost Estimate 04-011.xls]'!Total_Cost")

you may also have a look at the following thread (describing further
alternatives for accessing closed workbooks): http://tinyurl.com/2c62u
 
Back
Top