Link a hyperlink Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I m trying to create a text field with a hyperlink to an
address but I m geting an error that the hyperlikaddress
property is Read only for this Hyperlink

the code:

With Application.FileDialog(msoFileDialogFilePicker)
.Show

For Each a In .SelectedItems
With Me.Loan_Doc
.Value = a
With .Hyperlink
.Address = a
End With
End With
Next
End With
 
try to use this syntax:

With Me.Loan_Doc
..Value = a & "#" & "file://" & a
End With
 
Back
Top