Open Password Protected Workbooks in a Folder Through a Macro

Hey Guys,

I have a workbook full of password protected files (all different passwords.) I have a main excel file that contains the passwords for each of these files. What I would like this macro to do is to read the password for each file and open the files from the folder. So For instance this is how the password excel file would look:
A B
File XXX Password XXX
File YYY Password YYY

Thus, what I would like is for the macro to read the file name from column A and then open that file and input password that is in column B into the password prompt. Please let me know if this is doable?

Thanks

Yeah basically I have 20+ files in a folder and they all have separate passwords (they are confidential files.) Thus, instead of opening each file separately and entering in the password in each, I want to automate this process. Unfortunately, each file has a separate password that is stored in an excel sheet and these passwords change every year so I want to make it so that it reads from this file so that the macro is always relevant. Let me know if that makes sense.

Hi aditya88,

Try the attached file. Full code follows.

Lewis

Please Login or Register  to view this content.

Hey Lewis,

Thanks a lot for all your help, that worked like a charm! I need to make some small tweaks to suit my needs, but you've done all the grunt work. I really appreciate it.

FDibbins - reason I want them to be PW Protected is that all of these files are in our departments folder at work and only a select few should be able to access it, thus the files need to be password protected at all times.

Thanks,

Aditya