Consolidate multiple workbook with password

[emina002]

Hi All,

As we know there will be a macro/vba code to open a workbook with a specific password and how about if I have to consolidate multiple workbook with password?,how can i consolidate all files and ignore the password set by a user? Thanks for helping me or giving me ideas.

[mikeTRON]

Do you have workbooks that require a password to open or a password to unlock AFTER open?

If workbooks do not require a password to open you can use ADO to pull data VERY rapidly out of excel files without even opening them.

[emina002]

Actually I will consolidate multiple workbook that requires a password to open,and each workbook has a different password set by user(since they want their data to be private). After opening I will just copy the specific tab back to the consolidated file. How can I do this?

[mikeTRON]

ADO is out then.
You can use VBA but you will need the passwords (or you can just break the passwords and not save the files).

[emina002]

So is there a code where I can break password 1 by 1 all the workbook and not save at all?