Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to create the hyperlink from Excel doc. to the folder
Hallo,
I have a problem, I need to create the hyperlink from Excel doc. to the folder, but not to the existing document, is there any way to do it? Thank you |
#2
|
|||
|
|||
I used a formula like this:
=HYPERLINK("file:////c:\my documents\excel") And when I clicked on it, Windows explorer opened to that folder. Anton wrote: Hallo, I have a problem, I need to create the hyperlink from Excel doc. to the folder, but not to the existing document, is there any way to do it? Thank you -- Dave Peterson |
#3
|
|||
|
|||
I'm sorry, but unfortunatelly it doesn't work. See I need to make a link to
the folder on the local server, maybe that's a problem. I don't know. But anyway, Thank you a lot for your respond "Dave Peterson" wrote: I used a formula like this: =HYPERLINK("file:////c:\my documents\excel") And when I clicked on it, Windows explorer opened to that folder. Anton wrote: Hallo, I have a problem, I need to create the hyperlink from Excel doc. to the folder, but not to the existing document, is there any way to do it? Thank you -- Dave Peterson |
#4
|
|||
|
|||
You may want to post what you tried.
And if you want to link to a mapped drive letter or the UNC path. I don't have a network drive to test, but does: =hyperlink("file:////\\sharename\folder1\folder2") work? Anton wrote: I'm sorry, but unfortunatelly it doesn't work. See I need to make a link to the folder on the local server, maybe that's a problem. I don't know. But anyway, Thank you a lot for your respond "Dave Peterson" wrote: I used a formula like this: =HYPERLINK("file:////c:\my documents\excel") And when I clicked on it, Windows explorer opened to that folder. Anton wrote: Hallo, I have a problem, I need to create the hyperlink from Excel doc. to the folder, but not to the existing document, is there any way to do it? Thank you -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Click insert hyperlink, drill down to my network places until you find the
folder or file that you require and select it, should give something like this \\mydrive\DDRIVE (D)\excel\Loan payouts.xls "Anton" wrote: Hallo, I have a problem, I need to create the hyperlink from Excel doc. to the folder, but not to the existing document, is there any way to do it? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 97 freezes up when using hyperlink to another excel rpt file | Excel Worksheet Functions | |||
Unable to create any link/hyperlinks in a particular excel file | Excel Discussion (Misc queries) | |||
CREATE LIST OBJECT IN EXCEL | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
hyperlink to specific sheet in excel | Excel Worksheet Functions |