Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Opening related files by clicking file address
Hello,
I have the following file addresses pasted on an active worksheet. These are my related working files for my budget. E:\Doc-PK\[Budget 2010.xls] E:\Customer \[New 2010.xls] E :\Cash Flow \[Forecast 2010.xls] May I know if there is a way of opening these flies by just clicking on these file addresses ? Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Opening related files by clicking file address
Try insert|hyperlink
But you will have to enter the filename with the correct syntax (or point to them using that dialog). If your filenames were like: E:\doc-pk\budget 2010.xls (without the brackets) You could use another cell and a formula like: =hyperlink("file:////"&a1,"Click me") You could either remove the []'s manually (a couple of edit|replaces) or even use a formula: =substitute(substitute(a1,"[",""),"]","") Or even combine them into the =hyperlink() formula: =hyperlink("file:////"&substitute(substitute(a1,"[",""),"]",""),"click me") Mr. Low wrote: Hello, I have the following file addresses pasted on an active worksheet. These are my related working files for my budget. E:\Doc-PK\[Budget 2010.xls] E:\Customer \[New 2010.xls] E :\Cash Flow \[Forecast 2010.xls] May I know if there is a way of opening these flies by just clicking on these file addresses ? Thanks Low -- A36B58K641 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Opening related files by clicking file address
Hi Dave,
Thanks for your guidience. Now I can design a hyperlink template to open the link file selectively instead of opening all using Workspace Saving File. Best Regards Low -- A36B58K641 "Dave Peterson" wrote: Try insert|hyperlink But you will have to enter the filename with the correct syntax (or point to them using that dialog). If your filenames were like: E:\doc-pk\budget 2010.xls (without the brackets) You could use another cell and a formula like: =hyperlink("file:////"&a1,"Click me") You could either remove the []'s manually (a couple of edit|replaces) or even use a formula: =substitute(substitute(a1,"[",""),"]","") Or even combine them into the =hyperlink() formula: =hyperlink("file:////"&substitute(substitute(a1,"[",""),"]",""),"click me") Mr. Low wrote: Hello, I have the following file addresses pasted on an active worksheet. These are my related working files for my budget. E:\Doc-PK\[Budget 2010.xls] E:\Customer \[New 2010.xls] E :\Cash Flow \[Forecast 2010.xls] May I know if there is a way of opening these flies by just clicking on these file addresses ? Thanks Low -- A36B58K641 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening files by double clicking takes for ever - Word, Excel | Setting up and Configuration of Excel | |||
Opening file in Excel 2002 | Excel Discussion (Misc queries) | |||
Opening Excel by double-clicking a file doesn't work! | Excel Discussion (Misc queries) | |||
Opening an Excel file in a DIFFERENT process clicking on its SHORT | Excel Discussion (Misc queries) | |||
Formula related Crash on Opening File | Excel Worksheet Functions |