Hi,
I want to open a zip file which is protected with password using excel vba.
Hi,
I want to open a zip file which is protected with password using excel vba.
Do you know the password?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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.
The zip file is password protected...
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