Hello,
Using VBA I need to open a zip file where the excel file is password protected and save it on a designated location.
I am able to open the file but the issue right now is, each time I run the macro, I am being asked (via pop-op window) to locate the file and than once the file is located, it asks me for password before the file gets moved.
I want to designate the location of the zip file so it wont ask me for the path. Also I want to store the password so I a not prompted for it. Please note the zip file's name is not unique therefore name of file cannot be used to open it.
Can someone help?
Thanks
Using VBA I need to open a zip file where the excel file is password protected and save it on a designated location.
I am able to open the file but the issue right now is, each time I run the macro, I am being asked (via pop-op window) to locate the file and than once the file is located, it asks me for password before the file gets moved.
I want to designate the location of the zip file so it wont ask me for the path. Also I want to store the password so I a not prompted for it. Please note the zip file's name is not unique therefore name of file cannot be used to open it.
Can someone help?
Thanks
