Excel web query refresh

[cmb80]

Hi all, I would like to create a web Data query from the web in Excel that refreshes every 10 seconds.

It is for football scores. My current code is below, which runs the query each time - but Ijust wonder if there is a quicker way to do this which will just refresh the existing connection rather than creating a new one?

Please Login or Register  to view this content.

[cmb80]

BUMP! Can anyone assist on how to improve a triple web scrape?

I would ideally like to be able to start and stop the scrape as and when with a button