Hi
not possible with using the build-in INDIRECT function as this can't
access closed workbooks. But see:http://tinyurl.com/2c62u for some
alternatives. In your case INDIRECT.EXT should work. use a formula like
=INDIRECT.EXT("'C:\Documents and Settings\User\Dokumenter\[" & $H$2 &
"]fly'!$A$2")


--
Regards
Frank Kabel
Frankfurt, Germany


Semi29 wrote:
Jeg ville hører om man ikke kunne lave en sti hvor der var indflettet
en værdi fra en celle ?? F.eks.
='C:\Documents and Settings\User\Dokumenter\[hejsa.xls]fly'!$A$2
det er "Hejsa" jeg ønsker udskiftet med F.eks.$h$2
Således fil navnet kan ændres alt efter hvad der er valgt.

In english:
I have a path :
='C:\Documents and Settings\User\Dokumenter\[hejsa.xls]fly'!$A$2
Can't i change the name "Hejsa" to a Cell reff. f.eks. $h$2
So the name on the file change after what there are in celle $h$2

thanks