Try the INDIRECT function
=INDIRECT("'C:\week "&B1&"\[example.xls]Blad1'!$A$1")
(untested - no time today)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Negentropy" wrote
in message ...

Hi all,

Is there a syntax to make the path of a linked cell dynamic? I’ll
explain with an example:

Cell A1 is linked to another excel file, example.xls, in the folder
week 40.
So the formula in cell A1: ='C:\week _40_\[example.xls]Blad1'!$A$1

In this formula, I want the value _40_ to be dynamic, and read this
value from cell B1.
So lets say I put _41_ in to cell B1, the formula in cell A1 should
read ='C:\week _41_\[example.xls]Blad1'!$A$1

Any way to go about this? Thanks a lot in advance!

Cheers, Chris


--
Negentropy
------------------------------------------------------------------------
Negentropy's Profile:
http://www.excelforum.com/member.php...o&userid=27525
View this thread: http://www.excelforum.com/showthread...hreadid=470451