Open Multiple FIles that are password protected

[anniemay]

I have to open and copy data from between six and twenty files (it varies) on a network drive. The staff will give me their passwords so all I have to do is open each file and copy from Row 2 down to the bottom of their Sheet1 over to the master file Sheet3 and paste into the last row of sheet3, then close their file without saving. Would this have to be done one at a time or can it be done where the main workbook has it pre-recorded to do all at one time?

Also, this may seem way out to lunch but can two passwords be used so we can setup one password for all the files so we do not have to maintain a list off passwords?

 

[Tinbendr]

You'll have to loop through each one, using the password provided. :P

And, no, there is no Master password. (But what a great idea!)

Look at Ron's page about merging worksheets. You could adapter his code, then use an array to provide all the passwords.

You could also suggest departmental password standards. If they are in Sales, the the password for reports submitted to division managers is Sales222, Aqusitions333, etc. At least that way, you could operate with some efficiency, vs getting everyone's password and storing them.

 

[anniemay]

Hello David,

Thanks. I will look that over and see if it has what I need. The departmental password idea sounds like a good idea and will likely adopt that. Again, thank you.

 

[Michael M]

Further to Davids comments,
apart from each sheet having different passwords being a real pain, have you considered getting the passwords AND user names AND Sheet names relative to user, then creating a VERYHIDDEN sheet listing the same.
Then you may be able to do a For / next across the worksheets to that range of cells, that unprotects does the work and reprotects.

Just a thought. !!


And I agreee......a Master password....great idea !!!