How to make Workbooks.Open skip password protected files

[hoffey]

I have the following code, which does what it should but I wanted to add a clause to the last line to ignore all files that are password protected. There are a few hundred files, and pressing cancel on each one is tedious. It is not an option to use the password as an argument, so I am just trying to skip the protected workbooks.

Please Login or Register  to view this content.

[hoffey]

I added a blank password and added an "On Error GoTo" to skip over the file open. Works like a charm.

Please Login or Register  to view this content.