Web Query requiring manipulation

Hi all,

I have asked a similar question before with no reply so I am trying to explain it a bit better here.

I would like to pull data from a web query, which I am able to do and have attached below with the macro it created using the macro recorder. The data is for when a virtual horse was bought and for how much it was bought for.

The issue I have is I want to pull a range of data from the same website, but one parameter in the url changes each time.

So if possible I would like a macro to search same website, with it pulling data from the url 'http://www.digiturf.com/Betting/HorseDetails.aspx?HorID=6297321' with the 6297321 at the end being ranged from 6297321 to 6297999.

At the minute when I manually change the parameter in the macro the previous data stays and moves along for the new data. I am hoping if I can set a macro up to refresh the range mentioned above, it would simply move them along like it has been doing for me manually until all the data range has been pulled onto excel.

I have attached the file with the macro, but it may be a bit long winded as it is from macro recording. I have also pasted it below.

If anyone can help me with this it would be greatly appreciated.

Thanks
Gemma

Please Login or Register  to view this content.