VBA Word: How to point to a specified dir when a file dialog is open?

[sharon3874]

in VBA word, when I right click on some text, I can add hyperlinks upon the text. It will open up a file dialog allowing me to navigate and pick a file. My question is that how I can force the dialog box to point to a certain directory when it opens up?

Thanks a lot.

 

[CBasicAsslember]

Just put the path you want in the "Type the file or web page name" box. If you want to do it in VBA:

Option Explicit

Sub aTest()
    
Dim sLink As String
Dim sLinkText As String

sLink = "C:\Documents and Settings\<[i]user[/i]>\My Documents"
sLinkText = "This is the text"

    ActiveDocument.Hyperlinks.Add Anchor:=Selection.Range, Address:= _
        sLink, SubAddress:="", ScreenTip:="", TextToDisplay:=sLinkText
End Sub