View Single Post
  #5   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

On Jan 13, 12:19*pm, "David Biddulph" <groups [at]
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?- Hide quoted text -

- Show quoted text -

I cant seem to get indirect to work. Can someone give me an example of
how it would work with the concatenation of the path\file\sheet
Also is there a way to make the string with the = sign in front of it
evaluate instead of returning the concatenated string (a way around