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.