I've built a macro that updates data in certain cells every 60 seconds by web query, then writes that data to a graph.
Sometimes the web query gives a time-out error (causing a message box to pop up), which causes the spreadsheet to freeze until you click the "ok" button.
I want to put some code at the start of my macro, to the extent of
if [error box is present] then [click ok]
(... rest of code]
But I have no idea how to refer to that error box.
How do I do that? Or if there's a better way to deal with this, shoot!
Bookmarks