vba to open multiple password protected workbooks

[freda]

I have 35 workbooks, all with a different password.

I have started writing vba along the lines of:

Workbooks.Open FileName:= _
        "\\00 Quotes and orders 2005\Aberdeen.xls", Password:="password1", WriteResPassword:="password1"
       Workbooks.Open FileName:= _
        "\\00 Quotes and orders 2005\Birmingham.xls", Password:="password2", WriteResPassword:="password2"

..but it would get rather long winded to do all 35 like this.

I don't know much about arrays, but have the idea in my head that if I set up a loop of some sort to reference the file name and password each time (all files are in the same folder) it would make my life a lot easier.

Could anyone help? Thank you!

 

[9ballpimp]

What exactly are you trying to do? Do you want to open all 35 at the same time?? Please provide more details.

9ballpimp

 

[freda]

Initially I want to open all 35, so I can have a look at them whenever I want to .

In the long run, I want to open each one, copy a selection of data from it, paste it into a master workbook, close it, and go on to the next one until they are all done.

Does this help? Thanks for responding