Find and delete Corrupted files within a Directory

Hi Guys,

I have a directory (a single folder with no sub-directories within it) with 11,500 files in it, with file types: .pdf .xlsx .pptx .doc .docx .ods .xls
All of the files looks like they are fine within explorer (they have date modified, and file size greater then 0KB, the icon corresponding to the correct file type), however when opening many of the files, a corrupted warning appears, and the files are full of gibberish.

Does anyone know a way to file and delete the corrupted files, and spare the ones that still work?

Maybe something in Excel VBA, could go through each file individually and check them?

Thanks

*Bumping Thread for responses*

*Bumping Thread for responses*

Hi,

Thanks for the reply.
Fair enough, maybe asking excel to sort all corrupted files might be a bit much, however I know it's possible to open Word files with VBA (and excel files too), so I'd imagine there is a way to determine if there if an opened file has an error or not? I might be able to use that as a way to filter results. I'm just not too sure what the code would be for "checking for an error".
something like this could work for .doc .docx, .xlsx and .xls files.

Sorting them out manually I don't think is possible, too many files. Plus I'd like to have a tool that I can then use again in the future if the problem comes up again.

Hi,

I am trying to sort out office files (Microsoft word, Excel ,power point, and PDF); so excel should work well. However, Marc L, Thank you for your opinion, even if it's not helpful.

The code below almost works, except it stops if the excel file requires a password, or if the excel file asks to save when closed. Does anyone have any solutions to these to cases?

Please Login or Register  to view this content.

Originally Posted by Marc L

[INDENT]Hey VBA, can you rost my chicken ?!
Hey VBA, can you open the CD tray to hold my coffee ?!
Hey VBA, …

Please provide responses when you can help answer the question, rather than offering sarcasm.

The code below almost works, except it stops if the excel file requires a password, or if the excel file asks to save when closed.

Do you want to check only Excel files ??
Can you attach samples of corrupted files ?

Hi,

I've attached a file that is corrupted.
I believe the code I have supplied can handle corrupted files (if they are excel), however it is tripping up on password protected files.

Here is a copy of a file that is protected.

Just a note, Jimmy, regarding the "bumping" you did on posts #2 and #3. On some forums I think that may be a good idea. Here it is not, because all of our helpers have a convenient link at the top of the screen called "Unanswered Threads", this brings up a list of all posts with zero replies. As soon as you bump your own thread, you remove your thread from that list forever.

Oops.
So take on that. Patience wins the day.

Thanks for the heads up. I'll be more patient.

However that being said.. this thread still needs some help relating to protected files.

I have looked around the net, and still cannot find an answer,
Someone looked into changing files into .zip files to try and separate corrupted and protected however that doesnt seem to work.

*Bumping the thread*