I want to open a number of other files that are password protected from my main file. I know all the passwords and want to use code to automatically open and close the files after getting data from each file.

Any help greatly appreciated.

Nick