• 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.

Merge multiple password protected files

ANKUSHRS1

Member
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.
 

Attachments

AlanSidman

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