VBA Script to delete files gets error '53' when it finds a corrupt file

Hello,

I am in the process of deleting about 10,000 files from a shared network drive. I've identified the files to be deleted on a spreadsheet and the script runs, but sometimes stops with an "run time error 35 - file cannot be found. This has happened with about 10 files out of 4000, but one bad file stops the script every time.

I've noticed that the files that top the script show that there is an actual file with KBs of storage, but they will not open. I cannot open the file if I navigate to it and try to open it. Word docs start to open then Word shuts down and the PDF files that stop the script don't open either. They try to open then I get an access denied error. Some of these files have been moved so much and the libraries so poorly organized, perhaps a few files have gotten corrupt. I'm trying to delete about 200 files at at time and if I get an error in that range and keep narrowing it down until I find the file(s) that is holding it up.

Is it possible to have it continue past files that the script sees an error with??
I have attached a copy of the macro with the debug error highlighted in yellow. Thank you for taking a look!

How about adding some error handling or in this case ignoring but checking after ...?

Please Login or Register  to view this content.