Hyperling to text in a document

J

Johan

I have a macro that write a text in a document as hyperlink:

"file://c:\document and seting\test.xls"

The problem is that only part of the text (file://c:\document) comes as
hyperling.

Any who has a solution for on my problem??

Thanks in advance!!


Johan
 
P

Patrick Molloy

please show us your code

this code works fine

Option Explicit
Sub setlink()
Range("C5").Hyperlinks.Add Range("A1"), "file://c:\document and
seting\test.xls"
End Sub
 
Top