• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combining multiple Password Protected workbooks into a single workbook

Nitin Panjwani

New Member
Hi All,
I will be having around 85-90 password protected workbooks in 1 folder. They all will have different passwords.
I will have a list of the workbooks name and their passwords (preferably in sheet2).
I need a macro or code which will open the workbook with the password from the list, copy the data from the workbook and combine into 1 single master file.

PowerQuery is not available, hence that option is ruled out and so RDBmerge.
Any help would be greatly appreciated.
 

Attachments

vletm

Excel Ninja
Nitin Panjwani
Hint: If for some reason Your original thread went to ... somewhere ... then it can move to correct forum, instead to create new thread.
Valut's:
This time .. I'll close that.
 

Nitin Panjwani

New Member
Nitin Panjwani
Hint: If for some reason Your original thread went to ... somewhere ... then it can move to correct forum, instead to create new thread.
Valut's:
This time .. I'll close that.
Thanks vletm....
Could you please help me on this one.. Pls
 
Top