Is there is any way to unzip the password protected pkzip files using vba

Asked Aug 11 '20 at 14:51

Active Aug 11 '20 at 14:53

Viewed 22 times

Fname-"file need to unzip"

Dest_path-"path where fles need to be Stored after unzip"

Set oApp=CreateObject ("shell.application")
For each filename in oApp(Fname).items
    oApp.namespace(Dest_path).copyhere
Next

The above code is working fine for normal zip files..

edited Aug 11 '20 at 14:53

Paul Ogilvie

asked Aug 11 '20 at 14:51

RunA

1

Yes, if you know the password. – Paul Ogilvie Aug 11 '20 at 14:53
You probably need a command line tool. Check this post: https://stackoverflow.com/questions/15666282/how-to-unzip-a-password-protected-file-in-vbscript – Mike67 Aug 11 '20 at 15:28

0 Answers0