1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Discussion in 'VBA Macros' started by Sriram Iyengar, Mar 14, 2019.

  1. Sriram Iyengar

    Sriram Iyengar New Member

    Messages:
    23
    Hi All,

    I have 12 password protected files and want to merge them into a single file. How do I do this.
  2. ANKUSHRS1

    ANKUSHRS1 Member

    Messages:
    91
    do you have common password for all those files?
    Pls share some sample files.
  3. Sriram Iyengar

    Sriram Iyengar New Member

    Messages:
    23
    ADPP@BH

    is the password.

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

    Attached Files:

  4. Sriram Iyengar

    Sriram Iyengar New Member

    Messages:
    23
    ADPP@BH.. Sorry this is the password to be used
  5. ANKUSHRS1

    ANKUSHRS1 Member

    Messages:
    91
    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.

    Attached Files:

    Sriram Iyengar likes this.
  6. Sriram Iyengar

    Sriram Iyengar New Member

    Messages:
    23
    Awesome - Thank you so much
  7. AlanSidman

    AlanSidman Active Member

    Messages:
    459
    This can easily accomplished by loading the files into Power Query/Get and Transform and then append all the files.

Share This Page