Macro link to a webpage

[lpeters]

I need information that is in a link in a webpage. The link is to download information in the form of excel data.

How can I connect in an open workbook to a webpage and then download the link into my already open workbook.

Thanks so much,
Lisa

 

[CWatts]

It's called "Exteranl Data" in 2003 and in excel 2007 it's under the data tab and you click From Web.

It will aunch a mini browser in excel and you put your web address and select the table you want the data to populate from.

 

[lpeters]

I know how to grab a table from the external data tab.. but i need a link within the web page.

the link is to an excel workbook.. so basically i need to somehow tell excel to go to this site click on this link and brink there excel workbook into my workbook.. does that make sense?

 

[lpeters]

For example:
I want to go to this webpage
http://investor.shareholder.com/bhi/rig_counts/rc_index.cfm

then scroll down under North America Rotary Rig Counts - Current weak data and then insert the top sheet into my workbook..

then just have to refresh it everyweek.. is that possible if so how?