Is a workbook password protected?

Is it possible to programatically tell if a workbook is password protected before trying to open it?

I am processing large numbers of workbooks and want to avoid the ones with passwords as the process pauses with the Excel password dialog.

Any help would be greatly received.
Cheers

First let me say that I do not advocate breaking passwords, but this may be your only solution. A very well known author posted this link on his web site and as he states, this algorithm has been around a very long time and is well published. You might try this http://j-walk.com/ss/excel/faqs/pw.txt

Originally Posted by royUK

Is this what you mean?

Please Login or Register  to view this content.

Thanks Roy but doesn't this require the workbook to be open first ie the ActiveWorkbook? I am trying to determine if protected before trying to open it.

Originally Posted by Tarball

First let me say that I do not advocate breaking passwords, but this may be your only solution. A very well known author posted this link on his web site and as he states, this algorithm has been around a very long time and is well published. You might try this http://j-walk.com/ss/excel/faqs/pw.txt

Thanks Tarball, I'm with you on that and not sure I can blitz the password that might be on the workbook. Thanks for the suggestion though.