Monitoring utility for a Batch Process

Hi,

I have a Workbook "Batch.xlsm"
In which I have some Task Files listed that are opened one by one , some operation is performed and TaskFile is closed.

The problem that is being faced is that on some files the operation is not successful and the whole Excel application is crashed.

The purpose of a Batch Process is supposed to be the time saving and one cannot sit in front of PC till the batch completes.

Your precious thoughts are needed on "How to keep the batch continues by skipping the problematic file"
What should save the batch from stopping.

Skipping files is affordable but of course stopping batch is not desirable.

Help would be greatly appreciated

Any utility will also be a good choice

Brief description of the task: Basically every task file is scrapping data from a website. for different categories.

Best Regards

Imran Bhatti

Hello ImranBhatti,

Skipping files is affordable but of course stopping batch is not desirable.

Have you tried to add?:

Please Login or Register  to view this content.

Which goes in just before your Batch Processing starts?

Be aware that by doing this you may not be alerted to any other problems in your Code. So it would be good to Check and see if you end up with the desired results.

Regards

Yes winon I did this at first but it also resume next if the problem is inside the code of Batch File

I need not to resume next if the error occurs in the main code. it is like if I process an individual Task File by clicking different buttons and some error occurs and I skip this file and go to next file . Likewise the batch opens a task file uses the click events of different buttons in the Task file's userforms etc and waits untill the processing gets completed.Now if the problem is in Task File , the batch should skip this file and go to next file rather than stopping the batch at all

"This is something Dictator Application and I just want your ideas what algorithm should be used to handle this situation."

What's with the big red text?

Hi Ford

The Situation is described in small font in black.