V
Valeria
Dear experts,
I have a userform where I would like to put a link to a
certain folder - if you click on the link the folder opens
in a new window.
I have found an example by John Walkenbach at http://www.j-
walk.com/ss/excel/tips/tip71.htm only working for
hyperlinks:
Private Sub Label1_Click()
Link = "http://www.whitehouse.gov"
On Error GoTo NoCanDo
ActiveWorkbook.FollowHyperlink Address:=Link,
NewWindow:=True
Unload Me
Exit Sub
NoCanDo:
MsgBox "Cannot open " & Link
End Sub
How do I do the same for a simple folder on a certain
server?
Many thanks in advance for your help!
Best regards,
Valeria
I have a userform where I would like to put a link to a
certain folder - if you click on the link the folder opens
in a new window.
I have found an example by John Walkenbach at http://www.j-
walk.com/ss/excel/tips/tip71.htm only working for
hyperlinks:
Private Sub Label1_Click()
Link = "http://www.whitehouse.gov"
On Error GoTo NoCanDo
ActiveWorkbook.FollowHyperlink Address:=Link,
NewWindow:=True
Unload Me
Exit Sub
NoCanDo:
MsgBox "Cannot open " & Link
End Sub
How do I do the same for a simple folder on a certain
server?
Many thanks in advance for your help!
Best regards,
Valeria