Linking workbook to multiple other password-protected workbooks

[Joopers75]

Hi - I have a workbook that needs to gather regional data from multiple other workbooks (approx 35) that due to the sensitive data they hold, each have an individual password to open. As a result, when opening the regional copy, I'm of course being prompted for around 35 individual passwords in order for the links to be updated.

Would really appreciate it if someone could let me know how I can automate this process so the passwords are automatically provided for each workbook when opening the regional version. I don't need to physically open the other workbooks, just to provide the passwords so the links can update? I realise that's going to be a hefty amount of code so only need the code for one workbook and info on how I then can have that code loop until all workbooks are covered. Hope that makes sense.

Many thanks

 

[dragonmist]

I have a similar problem. I don't have nearly so many workbooks but the ones that I use I open and close many times during the day and it is very cumbersome to constantly enter the passwords.