Alternative to Hyperlink 2

[yont11]

I have a hyperlink button on a form that when clicked takes the user to a folder on a shared drive where they can choose a mail merge precedent letter. Is there a way to do this through VBA code without using a hyperlink? Thanks.

 

[CautionMP]

yont11,
If you simply want to open Windows Explorer and make it point to a particular folder you could use something like this (change the N:\Music to the path on the folder of your shared drive) :

Shell "explorer [i]N:\Music[/i]", vbNormalFocus

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[Remou]

Another option is FollowHyperlink

[tt]FollowHyperlink "C:\Documents\"
FollowHyperlink "C:\Data\TT.pdf"[/tt]

 

[yont11]

Thanks CMP & Remou. Does exactly what I wanted.