• 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


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

Merge multiple password protected files


I think the password protection is not obstacle to combine files. all you want to combine data which can copy the data in read only mode.( as your file open read only mode without password).
I have created a macro with this basis...
Please check and like if it works.



Active Member
This can easily accomplished by loading the files into Power Query/Get and Transform and then append all the files.