Extract Password Protected Multiple Zip files

[shridhar.dash]

Dear Forum

Please help with codes to extract multiple zip files into a specified folder.

Need to extract 1000s of zip file having one excel file in it. Every excel is password protected. Aware of the password and is also listed in an excel fie.

Can code be written to extract zip files which should lookup/check from the list of password stored and extract files / content to specified folder.

Please code at your earliest

[Andy Pope]

This should help get you started
http://www.rondebruin.nl//win/section7.htm

[shridhar.dash]

Hi, Its not as per my requirement. Need to extract password protected files where i have the set of password of respective file.
Appreciate your help on extraction of files from zip to a specified folder

[Andy Pope]

so the other part is to open the excel file with the matching password.

you can record a macro to do that and modify the code to replace fixed names with variable names.