PDA

View Full Version : VBA Help needed for 256 bite encryption using Winzip



watercooled8
04-20-2011, 07:00 AM
Afternoon,

Was wondering, if anyone could help me, i currently have a VBA script for winziping an excel file and password protecting the winzip file.

However, i need to tell winzip I to use 256 encryption. Please can anyone help?

My script is

Public Sub zipDLP(ByVal Password As String)
Dim source As String
Dim target As String

source = Chr$(34) & "S:\Temp\Temp.xls" & Chr$(34)
target = Chr$(34) & "S:\Temp\Temp.zip" & Chr$(34)

Shell ("C:\Program Files\WinZip\WINZIP32.EXE -min -a -s" & Password & " " & target & " " & source)

:dunno End Sub

orange
04-20-2011, 07:29 AM
I found this link while searching for
Winzip AES 256 bit encryption. I didn't see a reference to command line parameters for this however.
Hope it's useful to you.
http://www.winzip.com/aes_info.htm#extra-data

watercooled8
04-20-2011, 07:56 AM
Thanks for getting back, i did come across this site the other day, but could not make much sense from it.

I have been googling this for the last few days but to no joy as yet.

dicepackage
04-20-2011, 08:29 AM
I have used 7zip's 7za program with success. Try seeing if that will work if Winzip will not do it with the command line.
http://www.dotnetperls.com/7-zip-examples