WinZip from VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to WinZip a file from within VBA.
From other posts I see a bat file with:
start wzzip -u "G:\MySpace\MyZip" "G:\DbArea\*.*"

Do I just simply place this line (with my directories of curse) in a bat
file and run the bat from within VBA? Is wzzip an exe?

Thx.
 
If you have a licensed copy of Winzip, you can download an command line add
in that does that. Here is an example:

intZipVal = Shell(strZipPath & "wzzip -yp " & strFoxProPath & strZipFile
& " " & strFoxProPath & "wd*.dbf", vbNormalFocus)
If intZipVal = 0 Or Err.Number = 53 Then
MsgBox "Could not Create ZIP File for State Transmission" & vbCrLf & _
"ZIP File May be Created Manually for Transmission",
vbExclamation, "Error"
End If

If you don't have a license, get one! :)
 
Thanks for that.
If I install the WinZip add-in and then 'split' my database base, will the
front ends I distribute each contain the add-in? Thanks.
 
Back
Top