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