Create a hyperlink with concatenate and copy to a different workbo
 

Hello All,
I am trying to create a hyperlink using concatenate after I get the
hyperlink created I need to copy the hyperlink to a different workbook. Is
this possible? Thanks.

Create a hyperlink with concatenate and copy to a different workbo
 

Website = "http://example.microsoft.com"
Subdir = "/help"

set newbk = workbooks.open(filename:="c:\temp\abc.xls)

With newbk.Worksheets("Sheet1)
.Hyperlinks.Add .Range("E5"), Website & Subdir
End With

"akay71" wrote:

Hello All,
I am trying to create a hyperlink using concatenate after I get the
hyperlink created I need to copy the hyperlink to a different workbook. Is
this possible? Thanks.