link data in QueryTables

[shaggz7even]

im trying to recieve data from a table in a web page into excel that contains a link

when excel imports the data, the only only part i can see (or retreive from the cell) is the link text, not the actual link. but i can click on the link to go to the page and if i mouseover it, i can see th url

ie.
Amount Account Image Available
$90.72 27878877 YES <-- yes is the link text in
<a link=&quot;

http://blahblah.com/blah.htm&quot;>YES</a>

how might i retrieve this url from the excel sheet?

any help would be appreciated

-thanks

 

[PHV]

Have you tried to read the Address property of the Hyperlink object ?

Hope This Help
PH.

 

[shaggz7even]

how exactly would i go about doing that

getting the url from a cell

to get the text i use:

strData = ActiveSheet.Cells(y,x)

how do you suggest i get the url??

strData = ActiveSheet.Cells(y,x).Hyperlink.Address ?

that doesnt work. i've looked all over, the msdn library isnt helping at all

 

[PHV]

Try something like this:
strData = ActiveSheet.Cells(y,x).Hyperlinks(1).Address

Hope This Help
PH.