+ Reply to Thread
Results 1 to 6 of 6

How to combine multiple password protected excel workbooks into one master workbook(Macro)

  1. #1
    Registered User
    Join Date
    02-03-2022
    Location
    Cracov
    MS-Off Ver
    2019
    Posts
    3

    Question How to combine multiple password protected excel workbooks into one master workbook(Macro)

    Hello,

    We have three xlsx files with data ("file 1", "file 2", "file3") and one "All" file located in the specific folder/location.

    Each of the file is password protected.

    Files "file 1", "file 2", "file3" contain data stored in 3 the same columns: name, surname, date

    To achieve the goal, the data from these files ( "file 1", "file 2", "file3") should be transferred to the "All" file (columns: name, surname, date) automatically and the password protection cannot be removed from any of the files. The "All" file has to be refreshed of the new data from "file 1", "file 2", "file3", each time when it is opened.

    How to consolidate "file 1", "file 2", "file3 into one "All" through a macro?

    Thank You.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to combine multiple password protected excel workbooks into one master workbook(Ma

    Do you have the passwords for those files?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-03-2022
    Location
    Cracov
    MS-Off Ver
    2019
    Posts
    3

    Re: How to combine multiple password protected excel workbooks into one master workbook(Ma

    Sure,

    "file 1" - password: file1
    "file 2" - password: file2
    "file3"- password: file3
    "All" file - password: master

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: How to combine multiple password protected excel workbooks into one master workbook(Ma

    I would move them to a password protected folder and remove the passwords from the individual files themselves. Once in a secure folder, I would use the Combine (append) functionality in Power Query to bring all the data into the "Master" workbook.

    https://www.youtube.com/watch?v=nPlrQUbEn4o
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Registered User
    Join Date
    02-03-2022
    Location
    Cracov
    MS-Off Ver
    2019
    Posts
    3

    Post Re: How to combine multiple password protected excel workbooks into one master workbook(Ma

    Thank you so much for the Power query solution, but the requirement is to leave the passwords directly on the files.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: How to combine multiple password protected excel workbooks into one master workbook(Ma

    Good Luck. I've exhausted my abilities on this one.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Master workbook linked to multiple password protected files
    By bjbounds in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-11-2020, 02:36 PM
  2. Replies: 1
    Last Post: 12-13-2017, 09:38 PM
  3. [SOLVED] Combine multiple workbooks with multiple tabs onto a master workbook
    By loumarday in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-31-2016, 12:33 PM
  4. Combine several workbooks containing data in multiple sheets into a master Workbook
    By sunrize9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2014, 09:10 PM
  5. [SOLVED] combine multi workbooks into one master workbook but I want to combine only sheet 3
    By Goodstart14 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-31-2013, 12:22 AM
  6. Excel 2010 : Combine Multiple Workbooks into One Master Workbook
    By tehjagjr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2013, 05:07 PM
  7. Replies: 2
    Last Post: 03-30-2005, 09:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1