• 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

ADPP@BH

is the password.

Of the 300 files 84 files have different passwords (The password for these 84 files is either
ADQAPP/QAADPP
 

Attachments

  • MU_Billing_OCT2018.xlsx
    41.4 KB · Views: 17
  • MU_Billing_NOV2018.xlsx
    40.8 KB · Views: 12
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

  • combine.xlsb
    47 KB · Views: 103
This can easily accomplished by loading the files into Power Query/Get and Transform and then append all the files.
 
Back
Top