Hi all,
Bit of background, I have a live football scores/fixtures/events spreadsheet with a lot of API queries which generally works well, however, occasionally, when querying the API, there are errors in response which Excel flags up in a message box with an "OK" button.
Not sure what the cause of the errors is, but I'm pretty sure it's on the API as opposed to something going wrong with my sheet per se. The errors themselves don't bother me as they are few and far between and a simple click of the "OK" button and then running a new refresh of the query always solves the problem. However, I want these scores to continuously update without my supervision and unless I am there to click the "OK" button on the message box, then the spreadsheet is unable to continue it's normal operation when an error does flash up.
Is there a way (via VBA perhaps) that I can automatically "OK" these query errors when they flag, or even disable them completely?
Many thanks
A.
Bit of background, I have a live football scores/fixtures/events spreadsheet with a lot of API queries which generally works well, however, occasionally, when querying the API, there are errors in response which Excel flags up in a message box with an "OK" button.
Not sure what the cause of the errors is, but I'm pretty sure it's on the API as opposed to something going wrong with my sheet per se. The errors themselves don't bother me as they are few and far between and a simple click of the "OK" button and then running a new refresh of the query always solves the problem. However, I want these scores to continuously update without my supervision and unless I am there to click the "OK" button on the message box, then the spreadsheet is unable to continue it's normal operation when an error does flash up.
Is there a way (via VBA perhaps) that I can automatically "OK" these query errors when they flag, or even disable them completely?
Many thanks
A.
