Create a hyperlink to a word doc.

[madforgolf]

Hi Folks,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Is it possible to create a macro or code for the following issue?
<o> </o>
In column B I have a list of names (which could build to 500) that I aim to hyperlink each to their own word doc file. When adding a new name, can a macro run to check down the list to see if a hyperlink is made, if not add the link to a word doc using the same title as the cell in another folder. Thus it has to create the word file before it can be linked?
<o> </o>
I have a button that will put the names in alpha order.
<o> </o>
Cheers
Marty

 

[madforgolf]

I came across this today, is there more code that will help above question!The file name is where i have the folder.

Sub StartWordFile()
Dim docWord As Object
Set docWord = CreateObject("Word.Application")
docWord.Visible = True
docWord.Documents.Open Filename:="C:\Users\martin\Desktop\blank.doc"
End Sub