HyperLink

[CCkfm2000]

hi all..

i need to create a hyperlink to open a folder.

thanks

[OBP]

Where do you want to put this hyperlink?

[CCkfm2000]

i have a speardsheet with lots of spreadsheet file in them.

eg. cell a1 has a label "my files"

i need to click the cell which in turn will open the folder.

thanks

[geekgirlau]

If you type the UNC path to your folder (for example, \\server\share\myfolder (file://\\server\share\myfolder)), this will automatically create a hyperlink.

[Marcster]

Range("A1").Hyperlinks.Add Anchor:=Selection, Address:="UNC path here", _
ScreenTip:="Text to display when cursor is over cell", TextToDisplay:="my files"

To insert manually,
Insert > Hyperlink

Marcster.

[lucas]

or from a button....
Sub ExplorePath()
Shell Environ("windir") & "\Explorer.exe " & "C:\Temp", vbMaximizedFocus
End Sub