macro to extract page source of a website to excel

[congokin]

I am trying to get some urls from this webpage http://rivals.yahoo.com/ncaa/basketball/scoreboard?d=2011-02-20. I record a macro to dump all tables into excel but the urls i am looking for "boxscore" only show as a text and not as a link. But in the page source, the url is displayed. so is there a way for excel to get only the page source?

 

[congokin]

any takers???

 

[freesurf]

If you have hyperlinks on your worksheet, this page explains how you can extract the underlying url using a udf:

http://www.ozgrid.com/VBA/HyperlinkAddress.htm

Which probably prompts the question: how do I get the hyperlinks into excel in the first place?

For that use the "Get External Data" web query functionality:
http://www.mrexcel.com/tip103.shtml

You'll probably need to play with the query options, I suspect that Full HTML formatting will be needed to avoid the Boxscore coming over as plain text.

HTH

 

[Joneye]

Id love to find either VBA script or a method to do this with Mac 2011 excel.

A real big issues for me, any help would be of great assistance..

 

[congokin]

thanks for the 2 references. I have checked them but still could not get the link for "boxscore". this is the reason I wanted a macro that would download the page source...this contains the link

 

[freesurf]

sorry i'm stumped. the method to get the links onto an excel worksheet generally works. however, it does depend on how the webbuilder has configured the original tables. in this case, the hyperlinks are lost.

sorry i can't be more help this time.

 

[congokin]

thanks.