View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
Posts: 8,651
Default Concatenate path and file string for external reference

Use the INDIRECT function.
David Biddulph

"Michael" wrote in message
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

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