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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.