Hi all,
I am using a number of external links to various JSON APIs in my betangel automation Excel sheet, and recently I have been encountering a new error which basically breaks the automation capability of my sheet. The error reads
"We couldn't get data from an external source. Please try again later.
If the problem persists, please contact the administrator for the external data source..."
The thing is that it's not uncommong for the urls for the JSON data in my sheet to be wrong until they are connected to BetAngel to an upcoming race, and previously this has not been a problem, as the sheet would just happily attempt to refresh an incorrect JSON link without returning an error. However now with this error messagge, Excel will not do anything (including communicating with BetAngel) until I manually clear the error." Once I clear the error, and connect it to Betangel everything runs smoothly again, until it encounters an incorrect link again =/
I've tried the standard error bypass additions to macro code in Excel, none stop this error from appearing...
On Error Resume Next
Application.EnableEvents = False
Application.DisplayAlerts = False
I would have to re-code my Excel code significantly to try to avoid encountering these errors to make my sheet work without user intervention again, which I would really rather not do..
Any ideas?
