Import Hyperlink

  • Thread starter Thread starter Mrs. Ugh
  • Start date Start date
M

Mrs. Ugh

I have a spreadsheet that contains a field with hyperlinks to an external
URL. I have imported the data into a table with a field to hold the
hyperlink, but can't get the actual link to import. I tried importing the
field as a hyperlink, but all I get is the visible text, not the link info.
Any ideas?
Thanks,
Jill
 
I think you'll need to make the actual links visible in Excel before the
import. The you should be able to import them as text. If you leave them as
text, you'll be able to sort them but still work with them as you would with
a hyperlink. The appropriate code is something like:

Application.FollowHyperlink Me.txtHyperlink

where txtHyperlink is the name of a text box displaying the hyperlink
string.
 
Back
Top