Pool Master
01-23-2008, 11:54 AM
Hi Everyone,
This is my first post and I've only been writing macros for a couple of months, so please bare with me if my inquiry is unclear.
I'm using Application.FileSearch and Workbooks.Open to open multiple workbooks and perform the same action on each of them. My macro works just fine if there are no workbooks with passwords, however in this case some of these workbooks are password protected. I need the macro to skip any workbook that has a password and move on to the next. Any help is highly appreciated.
Thank you!
Adam
This is my first post and I've only been writing macros for a couple of months, so please bare with me if my inquiry is unclear.
I'm using Application.FileSearch and Workbooks.Open to open multiple workbooks and perform the same action on each of them. My macro works just fine if there are no workbooks with passwords, however in this case some of these workbooks are password protected. I need the macro to skip any workbook that has a password and move on to the next. Any help is highly appreciated.
Thank you!
Adam