Hyperling to text in a document

  • Thread starter Thread starter Johan
  • Start date Start date
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
 
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
 
Back
Top