Excel On Error Resume Next

A

AmjiBhai

Joined
Feb 21, 2018
Messages
216
Reaction score
86
On Error Resume Next
is such a great thing in Excel VBA that it simply helped me to establish continuity of my watch-dog.

I have got two excel shells one (my watch-dog) is keeping an eye on the other.
While the other is continuously watching my outlook inbox. Its constantly watching if a registered user has sent a query then it takes the query and extracts the desired records and drafts a reply to the user and sends it and loops back to the state of watching the outlook inbox. If due to any unforeseen reason the macro it this xlsb file gets interrupted then the watchdog which is running in the separate shell jumps in and re-execute the macro and gets back to his monitoring routine...

Got it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

On error resume next 8
On Error Resume Next problem 14
on Error goto 0 &on error resume next 3
on error resume next 2
On error resume next not working 3
on error resume next 1
On Error Resume Next not working 5
on error resume next dilemna 1

Top