Hi,
I've written a simple VBA code that allows me to download online bookmaker prices into my spreadsheet.
The problem is, that the data is spread over various webpages (about 20) and it takes too long to collect the data. On top of it I want the data to be refreshed every 3 minutes (one minute would be better).
My connection path looks like that:
Add(Connection:= _
"URL;http://www.valuechecker.co.uk/" & racename & ".html"
Racename is a variable. So if there are 20 races, I need to run 20 separate queries (with a "for each...next" loop) . I need to store all data in one sheet, as I need the data for a vlookup query.
Any idea how can I speed up the process?
Cheers,
hegisin
Bookmarks