Import Hyperlink

[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

 

[Arvin Meyer MVP]

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.