Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking to folders
Hope someone can help. I am trying to use excel to create a shortcut to our electronically stored files. Although I can use hyperlinks to link to specific files, is it possible to open a folder through a hyperlink or macro? Files are stored on a network and not on the hard drive in case this makes a difference. Thanks Sid -- Sidnoir ------------------------------------------------------------------------ Sidnoir's Profile: http://www.excelforum.com/member.php...o&userid=25916 View this thread: http://www.excelforum.com/showthread...hreadid=392893 |
#2
|
|||
|
|||
I don't have a network drive to test, but I selected A1 and hit
insert|hyperlink. I typed in: c:\my documents And when I clicked on it, it opened windows explorer to that folder I would think that: N:\my documents or \\share\path would work the same way. If you're trying to open a folder to select a *.xls file to open, you may want to look at application.getopenfilename (for your macro). Sidnoir wrote: Hope someone can help. I am trying to use excel to create a shortcut to our electronically stored files. Although I can use hyperlinks to link to specific files, is it possible to open a folder through a hyperlink or macro? Files are stored on a network and not on the hard drive in case this makes a difference. Thanks Sid -- Sidnoir ------------------------------------------------------------------------ Sidnoir's Profile: http://www.excelforum.com/member.php...o&userid=25916 View this thread: http://www.excelforum.com/showthread...hreadid=392893 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read only folders | Excel Discussion (Misc queries) | |||
conditional forming causing linking errors | Excel Worksheet Functions | |||
Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
Have to use cursor keys cannot use mouse in excel when linking fo. | Excel Worksheet Functions | |||
Linking Workbooks | Excel Worksheet Functions |