how to open a folder from a userform

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
 
B

Bob Phillips

Valeria,

Just replace the http link with the network folder name.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top