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
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