I have done a little bit of programming to interphase with Excel and
Internet Explorer. I can give  you a start off on how to connect and read
I hope this will help you to carry on your further investigation.

Dim ie as Object

'Create an object to Internet Explorer
Set ie = CreateObject("InternetExplorer.Application")

path1 = "http://www.google.co.in/ <http://www.google.co.in/> "

ie.Visible = False
ie.Navigate (path1)

'Wait till explorer navigate's to the page
While (ie.Busy = True)
Wend

'All the text on the current window will be assigned to strdata variable
strdata = ie.Document.body.innertext

You can search for the data you are looking for from this strdata
variable. Hope this helps :)

well i'm not sure exactly what is wanted here.. but excel  (2003 at least) has
the capability of querying a web site/table you should be able to connect to the
website select the table you want and excel will import the data, i believe
it'll link  to the data so it will change.. if you record the macro of the steps
then you can rerun it at your leisure

Very elegant solution. It has sparked off some ideas for something I was
planning to do, and now it has suddenly become much easier.