Excel Web Query

[Royville]

I hope this post is not out of order here as it's really more of an excel query than a ba, but I don't know where else to ask (Apologies!)

I want to write some vba code that excel can use to download the 'next race' page (every minute or so) from the racing posts web site.

Is this even possible? Once I can do this I have some ideas I'd like to try with analysing the data.

I hope someone can offer me some guidence or point me in the right direction.

Kind regards
Royville

[Ian]

What data is there on the RP racecard that you need to update every minute ?

[Royville]

Hi Ian,
You miss understand. I just want it to update with the next race details after last race has started.
If you look down the right side of the page you'll see a link which says 'next race' and if you click it, it brings up the next race card.
I want it to update every minute or so because when the page changes my analysis program should kick in, so the sooner it updates the more time there is to analyse before race start.
Hope this makes sense
Regards
Royville

[KevinTHFC]

If you click on the next race link you actually go to something link below
http://www.racingpost.com/horses2/cards ... 2010-10-07

[KevinTHFC]

Grr no edit

The date and race id will need to be determined by your code. Obviously the date is easy but the race id will be a little more tricky.

To be honest with I used to automatically download the complete days cards but have given up as the RP keeps changing its layout and this means you have to keep rewriting your code