Extracting URL and Label from non formula hyperlinks

  • Thread starter Thread starter cmlnr
  • Start date Start date
C

cmlnr

I have a huge data file that someone sent me. It was copied from a we
page and has several hyperlinks. Obviously, since it was take
directly from a webpage, the links were not created using HYPERLINK.

I need to process the data in Perl, but before doing that, need t
parse out the URL and the label from each of the links in the file.
I'm pulling my hair out trying to figure out how to do it!

If I can avoid VB Script, that would be best, but any help would b
appreciated. FYI, using Excel 2000.

Thanks
 
Hi cmlnr (talk about names without vowels),

You would need a macro or a User Defined Function,
I would suggest a UDF, see
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyperlinkaddress

Function HyperlinkAddress(cell)
On Error Resume Next
HyperlinkAddress = cell.Hyperlinks(1).Address
if hyperlinkaddress = 0 then hyperlinkaddress = ""
End Function

usage:
=HyperlinkAddress(A2)
=personal.xls!hyperlinkaddress('links sheet'!A2)


If you need help installing and using macros and UDFs see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

If you have the web page and want to see the hyperlinks, there
are several different kinds of solutions available.
http://www.mvps.org/dmcritchie/ie/bookmarklets.htm
look for "href visible" and click on it. Also
http://www.bookmarklets.com/tools/data/index.phtml
look for "list of all links" and click on it
--
 
Back
Top