View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ariel Ariel is offline
external usenet poster
 
Posts: 38
Default Creating a hyperlink in Word from Excel

I am creating a word document using Excel and I need to add a hyperlink at a
given position in the text. For some reason the following code does not work.
WordApp has already been dim'ed.


With WordApp.ActiveDocument
.Hyperlinks.Add Anchor:=Selection.Range, Address:= _
"http://www.asdfasdfasfd.com", SubAddress:="", _
ScreenTip:="", TextToDisplay:="Activity"
End With