Hey there, this is my first time on a forum....

I need to link from a worksheet to another file. Instead of creating this link normally (just by opening the other file and selecting the desired cell), I am trying to assemble the link from a number of different cells in different worksheets...

for example.

Cell A1 in worksheet1 = long file path

something like - file://nuefil08\nuefeb4\Work\Data Entry\31.03.05\EM22.xls

Cell A1 in worksheet2 = worksheet name and cell reference

something like - Monthy Totals Line 1!C$159

The link should be the sum of the 2 cells, however whatever I have tried, excel only returns the text string, not the actual value of the cell from the link...

I've been trying everything for 2 days and it's starting to do my head in... Any help would be appreciated! Cheers...