Retrieving hyperlink from MS Access database

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

Guest

Hi!

I have problem to retrieve hyperlinks from MS Access database to Excel
worksheet (ADO). everytime when a hyperlink is retrieved to the worksheet it
is wrapped with # from both sides for eg: #http:\www.cnn.com# and the link is
not working.

any suggestions?

Thanks in advance for your help!

regards
E
 
I don't know how to prevent this, but I do know how to fix your "im-pounded"
hyperlinks. Select the cells and run:

Sub hyper_fixer()
For Each r In Selection
r.Value = Mid(r.Value, 2, Len(r.Value) - 2)
r.Select
Application.SendKeys "{F2}"
Application.SendKeys "{ENTER}"
DoEvents
Next
End Sub

This sub removes the leading and trailing pound from each cell and then does
F2 to the cell to make the hyperlink "hot"
 
Thanks!

Eli

Gary''s Student said:
I don't know how to prevent this, but I do know how to fix your "im-pounded"
hyperlinks. Select the cells and run:

Sub hyper_fixer()
For Each r In Selection
r.Value = Mid(r.Value, 2, Len(r.Value) - 2)
r.Select
Application.SendKeys "{F2}"
Application.SendKeys "{ENTER}"
DoEvents
Next
End Sub

This sub removes the leading and trailing pound from each cell and then does
F2 to the cell to make the hyperlink "hot"
Click to expand...
 
Back
Top