macro to create a hyperlink from excel to word document.

Hi there.

I'm programming a macro which have to open a word document and (besides other stuff) create a hyperlinks in the opened word document. I've tried the next code

PHP Code: 

Sub escribe()
    Dim objword As Word.Application
    
    Set objword = New Word.Application 'Creo el objeto word
    objword.Documents.Open "C:\Users\ggc\Desktop\Informe2.doc" 'Abro el documento
    objword.Visible = True
  
    objword.Selection.GoTo What:=wdGoToBookmark, Name:=here
    objword.Selection.InsertAfter "link"
        
    objword.Selection.Hyperlinks.Add Anchor:=Selection.Range, Address:= _
        "Informe.doc", SubAddress:="", ScreenTip:="", TextToDisplay:= _
        "link"
End Sub 


but the last sentence doesn't work. I've been looking for a solution but couldn't find anything similar, so I hope one of your expert excel minds may help me!!!
thank you!!!!!

Thanks you for your quick answer but sadly doesn't work. I mean, it pastes in the word document the selected area, but doesn't add the hyperlink I need.

that's, I meant that kind of hyperlink which you click on it and opens another file, web site, etc. But it doesn't still work, excel says me: "wrong number of arguments or invalid property assignment"
Maybe I do something wrong, my excel code is:

PHP Code: 

Sub escribe()
    Dim objword As Word.Application
     
    Set objword = New Word.Application 'Creo el objeto word
    objword.Documents.Open "C:\Users\ggc\Desktop\Informe2.doc" 'Abro el documento
    objword.Visible = True
   
    objword.Selection.GoTo What:=wdGoToBookmark, Name:="nombre"
    objword.Selection.InsertAfter "link"
    objword.Selection.Hyperlinks.Add Anchor:=Selection.Range, Address:="C:\Users\ggc\Desktop\Informe.doc", SubAddress:="", ScreenTip:="", TextToDisplay:="name_that_you_want_to_show"
End Sub 


yep you were right, but I've just tried with an hyperlink to another excel and I've got the same problem. The line which causes the problem is:

Please Login or Register  to view this content.

I think the problem comes up from selection.range, but I'm not sure, cause I don't understand why, because the previous instructions write "link" and let it selected, so...

Ollie thank for all!!!!!!! but... doesn't work. I've tried with fresh word and excel documents and diferent extensions (you know, doc, docx, xlsm, xls, xlsx) but the error persists d'oh!! hahaha. Any suggestion? hahaha

You're awesome!!!!!!!! that's!!!!! Thank you so much!!! it was driving me crazy!!!!