What is the best way to automate the clearing out of an error message that pops up a few times a day in Excel?
Basically every now and then I get a "deadlock error" which causes a small window to pop up on the screen. Someone then has to go in and click OK and then refresh to resume the Excel process.
No need to get into the deadlock issue. We know what is causing it but still want to find a work around.
I'm trying to find a windows macro, VBA marco or something similar that will detect when this message comes up and OK's past it to resume the auto-refresh process in Excel.
What is the best way to go about this?
What is Excel being use for here? I'm asking because you might not even need for it to be running to update it.