Hi, is there a bit of VB Code I can use to create a Report in Excel which looks as all Excel files on a specified Drive and tells you if they are password protected?

E.g.

Search C: Drive for all *.xls files, then shows the file path and the result whether a password is required to open the file:

Please Login or Register  to view this content.
Thanks and regards
Tom