Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a hyperlink in Word from Excel
About the only thing I do with MSWord is record macros and try to tweak them.
But Selection.Range doesn't look like it belongs to the MSWord application. I'd try: With WordApp.ActiveDocument .Hyperlinks.Add Anchor:=.Range, Address:= _ "http://www.asdfasdfasfd.com", SubAddress:="", _ ScreenTip:="", TextToDisplay:="Activity" End With Ariel wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a hyperlink in Word from Excel
Without specifically defining the location where this should be inserted,
everything else in the document is deleted. "Dave Peterson" wrote: About the only thing I do with MSWord is record macros and try to tweak them. But Selection.Range doesn't look like it belongs to the MSWord application. I'd try: With WordApp.ActiveDocument .Hyperlinks.Add Anchor:=.Range, Address:= _ "http://www.asdfasdfasfd.com", SubAddress:="", _ ScreenTip:="", TextToDisplay:="Activity" End With Ariel wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a hyperlink in Word from Excel
Maybe it's time to ask in an MSWord newsgroup.
Ariel wrote: Without specifically defining the location where this should be inserted, everything else in the document is deleted. "Dave Peterson" wrote: About the only thing I do with MSWord is record macros and try to tweak them. But Selection.Range doesn't look like it belongs to the MSWord application. I'd try: With WordApp.ActiveDocument .Hyperlinks.Add Anchor:=.Range, Address:= _ "http://www.asdfasdfasfd.com", SubAddress:="", _ ScreenTip:="", TextToDisplay:="Activity" End With Ariel wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a hyperlink in Excel. | Excel Discussion (Misc queries) | |||
Excel Hyperlink doesn't open Word doc the same way as Word does | Excel Discussion (Misc queries) | |||
Creating a Hyperlink from a Single Word | Links and Linking in Excel | |||
Creating Hyperlink in excel 2003 VBA | Excel Programming | |||
CREATING HYPERLINK IN EXCEL | Excel Discussion (Misc queries) |