View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Concatenate path and file string for external reference

Normally with something like this you would then use the INDIRECT
function. However, this does not work on closed workbooks.

If it is important to you, you can download a free add-in called
morefunc (do a Google search for sites where this can be downloaded),
and this gives you a new function which can be used like this:

=INDIRECT.EXT(cell)

where cell contains your concatenated reference.

Hope this helps.

Pete

On Jan 13, 4:58*pm, Michael wrote:
I am trying to create a linked external reference by concatinating the
info together.
I have in 3 cells:

path * *file * *sheet
H:\Dev\ [fromModel.xls] Sheet1'!$B4

I concat them to create what should be the reference
='H:\Dev\[fromModel.xls]Sheet1'!$B4

But it just returns the string. How do I get it to evaluate?