HI, I was hoping someone might be able to help me. I'm looking for a macro that loops through workbooks saved in one folder and combine specific worksheets into one workbook (as separate tabs). The worksheets can either be called the same thing or be the 3rd, 4th and 5th worksheets in the original workbooks. The issues that I'm coming across is that the workbooks are closed and the worksheets are password protected in their original locations. Can anyone help me?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Macro to combine password protected worksheets from separate closed workbooks into one workbook
- Thread starter Carrie99
- Start date
