Hi there 
I have a batch macro that opens multiple Excel files since the schema changes. However, at times there will be a file that is corrupted and the macro doesn't work. I found online a Python script that would identify the files whose Error Message says "File is Not a Zip File". I was planning on filtering those files dynamically so that I don't have to pull the workflow out of production whenever there's a new corrupted file.
On Picture 1, I have the error message. Plus my attempt to use the Python tool which identifies the corrupted files, but somehow is unable to filter those files out.
On Picture 2 is just my batch macro. I'm thinking adding the Python tool and filter here would solve the issue. But I don't know how to put it all together.
How would I configure the batch macro for this additional step to check if a file is corrupt or not? Any ideas on how to solve this issue?
I'd appreciate any suggestions.
