Retrieving hyperlink from MS Access database

[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

 

[Guest]

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"

 

[Guest]

Thanks!

Eli

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"