I am doing a data query but sometimes when the code asks it to refresh it just hangs and never updates the data and never returns to the code so I have to use task manager to crash Excel and restart. Is there a way to handle this or a better way to do it?
The website I am querying is:
http://hk.racing.nextmedia.com/allodds.php
and the code that gets stuck (only sometimes) is:
Range("AppleOddsCorner").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Many thanks if you can advise.
The website I am querying is:
http://hk.racing.nextmedia.com/allodds.php
and the code that gets stuck (only sometimes) is:
Range("AppleOddsCorner").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Many thanks if you can advise.