To unzip password protected zip files using VBA

hii

I have a bunch of zip/rar files in a folder which are all protected with a different password all known to me.

I require a VBA code which will allow me to browse & select that folder & extract the file from all zip/rar files using the password specified in column B of the sheet.
(Column A will contain the name of the zip file to look in the folder)

Any help on this would be appreciated..

Thank you.

.
Ron deBruin has examples on his website that will assist.


Of particular note is a Text File he has included that outlines various WinZip options not commonly known. One option is the PASSWORD. His description :

"Extracting Files
****************

The command format is:
winzip32 -e [options] filename[.zip] folder
where -e is required.
options
-o and -j stand for "Overwrite existing files without prompting" and "Junk pathnames", respectively.
Unless -j is specified, folder information is used. Use -sPassword to specify a case-sensitive password.
The password can be enclosed in quotes, for example, -s"Secret Password".

filename.zip
Specifies the name of the Zip file involved. Be sure to specify the full filename (including the folder).

folder
Is the name of the folder to which the files are extracted. If the folder does not exist it is created.
"

So, if you wrote the macro to 'loop' through the list you provide and specify the OPTIONS to refer to a variable for
the password in the list ... you should be able to perform the function you are seeking.

Look at this resource, POST #4 : https://www.pcreview.co.uk/threads/u...words.3779569/