How can I create new hyperlink with VBA. The path I want to use is:
C:\Test\test.xls

Thanks in advance.

Maperalia

this will put it in cell a1 on sheet1

Sub test()
With Worksheets("Sheet1")
.Hyperlinks.Add .Range("A1"), "C:\Test\test.xls"
End With


End Sub


--


Gary


"maperalia" wrote in message
...
How can I create new hyperlink with VBA. The path I want to use is:
C:\Test\test.xls

Thanks in advance.

Maperalia

Gary;
Thanks very much it is working perfectly.

Maperalia

"Gary Keramidas" wrote:

this will put it in cell a1 on sheet1

Sub test()
With Worksheets("Sheet1")
.Hyperlinks.Add .Range("A1"), "C:\Test\test.xls"
End With


End Sub


--


Gary


"maperalia" wrote in message
...
How can I create new hyperlink with VBA. The path I want to use is:
C:\Test\test.xls

Thanks in advance.

Maperalia