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?
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?
