Automate response to protected files
I'm attempting (via automation from .Net) to scroll through a list of Excel
files and do something (which is immaterial to this question) with those
files.
That is working - until I get to a file which is password protected where
when I try to open the file it pops up the password box and stops my code.
Is there a property of the workbook that I can grab that says "this is
protected" so that I can skip that file?
|