VBA - skip files that are password protected
Posted on 2011-09-08
I have a macro that cycles thru a group of Excel files inside a folder and makes updates. A small number of the files are password protected. I don't need to update the password protected files. One issue I have right now is I'm not able to get rid of the pop up that requests the password. When a file is password protected, I'd like to be able to identify it's password protected (or that I wasn't able to open it) and then move on. How would you suggest I go about accomplishing this? I'm just looking for the code right around the workbook open statement.
I'm currently using Excel 2003.
Thanks for your help,