Create Hyperlink

[Guest]

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

Thanks in advance.

Maperalia

 

[Gary Keramidas]

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

 

[Guest]

Gary;
Thanks very much it is working perfectly.

Maperalia