ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Create a password protected Zip file (https://www.excelbanter.com/excel-programming/444739-create-password-protected-zip-file.html)

hrdk mstry

Create a password protected Zip file
 

Hi Experts,

Kindly help me.

I have a query and despiratly need your help.I want to creat a zip file with password protection.please suggest me.

Explaination to the requirement:

There are 4 files in a folder,I want to convert that folder to password protected zip file and then attach the file in the mail, using VBA(Macro).

PLEASE help me.




GS[_2_]

Create a password protected Zip file
 
hrdk mstry expressed precisely :
Hi Experts,

Kindly help me.

I have a query and despiratly need your help.I want to creat a zip file with
password protection.please suggest me.

Explaination to the requirement:

There are 4 files in a folder,I want to convert that folder to password
protected zip file and then attach the file in the mail, using VBA(Macro).

PLEASE help me.


Have you tried the options in the SaveAs dialog? This may require a zip
utility such as WinZip or the like.

I use my own file explorer which has a SaveAs option on the right-click
menu. It works nicely with files but I've never tried it with a zip
archive. I'll test this out and report back...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc




All times are GMT +1. The time now is 03:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com