Sti / path?

[Guest]

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

 

[Frank Kabel]

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")

 

[Guest]

Tanks
I have try with Indirect it dosn't work
do you know where I can get Inderect.ext ?
I can't find it at http://longre.free.fr/english/

Hope you can help -- But remark I'm not so good in Excel

Alvin


"Frank Kabel" skrev:

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

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

 

[Guest]

Yes yes I see it no and it works thanks thanks
I'm very glad for your help
I have another ?
I have a dropdownboks no problems if i use it normal
but can't I use it with several Celle reff.
i would like to have teh reff. from B1 And F1 And J1
in my dopdownboks can I this??

Best regards

Alvin


"Frank Kabel" skrev:

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

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