Use Cell Content to Build Link

[flattire00101]

Hi -

I am trying to link one cell to another cell in another document on th
network. The actually linking of the cells is eas
"=http://server/folder/[filename.xls]Sheet1'!$A$1" but the part I can'
get is ...

I want to use another cell's content as part of the url. For example
if cell A1 contained the folder that the file was in then, then I woul
want to use that value so that I could change the folder in all of th
links at one time. For example, if A1=temp, then the link would b
"=http://server/temp/[filename.xls]Sheet1'!$A$1". I've trie
"=CONCATENATE("=http://server/",A1,"/[filename.xls]Sheet1;!$A$1)" ..
it puts together the string correctly, but then the target cel
displays the link, not the contents of the remote cell.

I think if there's an actual function that retrieves the cells content
(instead of just an equals sign) I would be set, but I can't figure tha
out. Thanks for the help

 

[bj]

try the indirect function
=indirect("=http://server/"&A1&"/[filename.xls]Sheet1;!$A$1)")