ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Detect Whether Workbook Has Pwd Without Opening It (https://www.excelbanter.com/excel-programming/358099-detect-whether-workbook-has-pwd-without-opening.html)

MDW

Detect Whether Workbook Has Pwd Without Opening It
 
I've got some VBA code that opens various Excel workbooks and tests their
contents. Occasionally, I run across workbooks that are password protected.
There's no way I'm going to know what these passwords are, nor do I care. I'd
like the code to simply skip over these files and not open them.

Does anyone know of a way to examine a file (either with Excel or with the
FileSystemObject) and tell whether it's got a password?

Incidentally, I'd like to do the same thing if the workbook is protected as
well.

I'd appreciate any advice you might have.
--
Hmm...they have the Internet on COMPUTERS now!


All times are GMT +1. The time now is 10:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com