PDA

View Full Version : Open Password protected zip file using vba



msherifam01
10-03-2013, 01:08 AM
Hi,

I want to open a zip file which is protected with password using excel vba.

Aussiebear
10-03-2013, 02:54 AM
Do you know the password?

msherifam01
10-03-2013, 03:55 AM
yes.. I want to open it through vba coding...

currently i use

Set oApp = CreateObject("Shell.Application")
oApp.Open (Fname)

with this i will supply the password. i don't how to do it.

Kenneth Hobs
10-03-2013, 06:53 AM
http://www.rondebruin.nl/win/section7.htm

msherifam01
10-06-2013, 03:26 AM
The zip file is password protected...

Kenneth Hobs
10-06-2013, 05:24 PM
The answer depends on what 3rd party programs you have. Rons explains that in the reference that I gave you.

Winzip and 7-zip are two popular ones. Ron and others have examples of those. For 7-zip, here is another example. http://exceldatabase.comuf.com/vba.html