I'm pulling data every minute from the web via api however occasionally a window pops up with an error message "DataSource.Error: Web.Contents failed to get contents" and everything stops. Once I hit the OK button on that window everything works fine again. I realize that occasionally I will have errors like this because of the server I'm pulling the data from so I'm just accepting this. However is there a way in Excel to ignore an error like this or hit ok button automatically using vba script or do something to make it work continually even if such error pops up?
Thanks in advance.
Thanks in advance.