extracting links in a HTML file into cells
Posted by freddi furnin on October 01, 2000 4:42 PM
I have a webpage with links. The file shows "abc" for a hyperlink to "www.abc.com". I open it into excel97. Using right buttton...hyperlink...copy hyperlink and then Paste as hyperlink, I can paste www.abc.com in a new cell.
Yet when I try it as a macro I get "abc" (with www.abc.com" as the underlying link. I just want a new cell with "www.abc.com" there.
I'm a beginner so can anyone help me?