Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sti / path?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sti / path?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sti / path?
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 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sti / path?
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Path Too Long? Not Anymore! Check out Long Path Tool | Excel Discussion (Misc queries) | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions |