Quote Originally Posted by dangelor View Post
Glad I could help!
Hey!

So i jumped the gun a bit haha!

I tested it on 6 spreadsheets and it worked great.

I just tried to run it on the ones that i needed which, at the time, i didnt realise that it was 1008 spreadsheets! My colleague didnt warn me.

It changed alot of them, but threw up an error, saying it could access one of them. Maybe he didnt set the correct password for example.

Is there a way to add something like On Error Resume Next somewhere. I only found that with some research, but wasnt sure if that was the correct way to go about it.

The other thing was that some of the files are .xlsx , so could it be changed to look for anything containing *.xls* for example, because looking at the code you provided, it looks at the last 4 characters for that, but if i change it, it throws up an error about the others.

So to round up, it would be great if it could ignore errors and move on (the dream being it listing the files causing the issue) but if thats a pain, not a problem.

And to also search for files containing xls

Cheers