I have a macro that will zip a file using Winzip and then email.

My problem is, when using WinZip 9 there is an option to encrypt th
file but I am unsure how to build this into my macro.

Does anyone have any ideas?


Thank

--
mikeyma
-----------------------------------------------------------------------
mikeymay's Profile: http://www.excelforum.com/member.php...fo&userid=3269
View this thread: http://www.excelforum.com/showthread.php?threadid=52526

Hi Mike

On this page
http://www.rondebruin.nl/unzip.htm

Click on the parameters link (3)




--
Regards Ron de Bruin
http://www.rondebruin.nl


"mikeymay" wrote in message
...

I have a macro that will zip a file using Winzip and then email.

My problem is, when using WinZip 9 there is an option to encrypt the
file but I am unsure how to build this into my macro.

Does anyone have any ideas?


Thanks


--
mikeymay
------------------------------------------------------------------------
mikeymay's Profile: http://www.excelforum.com/member.php...o&userid=32699
View this thread: http://www.excelforum.com/showthread...hreadid=525264

Use -sPassword to specify a case-sensitive password. The password can b
enclosed in quotes, for example, -s"Secret Password"

Hi Ron

I did actually pick up this link on another forum, but didn't look har
enough obviousley :-)

Does this mean the password required when selecting the encryptio
option?


Thank

--
mikeyma
-----------------------------------------------------------------------
mikeymay's Profile: http://www.excelforum.com/member.php...fo&userid=3269
View this thread: http://www.excelforum.com/showthread.php?threadid=52526