View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael[_4_] Michael[_4_] is offline
external usenet poster
 
Posts: 27
Default Concatenate path and file string for external reference

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?