HTML Number Grabber to Excel

Status
Not open for further replies.

eipeks

In Runtime
Messages
303
Here's what I want to do:

1) Grab numbers off a website

2) Load them up in an excel spreadsheet

3) display the numbers/stats on my own website

For example... if I wanted to grab hockey stats off the nhl.com website and load up on my won website, how can I do this w/o manually entering every number. Then when nhl.com updates thier info mine would update. This is just an example...hockey stats are not what I'm actually going for.

I heard there is a way to do this....anyone know?
 
Excel macro programming (something like Visual Basic).

I made a similar excel script once to get the bandwidth usage from the ISP's website and add em up in excel spreadsheet. My internet was (a long time ago) capped on bandwidth/month.

Shell(prgm) is your friend. It's actually quite simple to launch internet-explorer or some other browser from macro then read it's contnents using innerText or innterHTML

Look up some things on VB Macro scripting
 
Status
Not open for further replies.
Back
Top Bottom