WinZip from VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Doug F. - 29 Jun 2005 21:32 GMT

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.

Signature

Doug F.

Reply to this Message

Klatuu - 29 Jun 2005 23:19 GMT

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! :)

> I need to WinZip a file from within VBA.
> From other posts I see a bat file with:
[quoted text clipped - 4 lines]
>
> Thx.

Reply to this Message

Doug F. - 30 Jun 2005 00:24 GMT

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.

Signature

Doug F.

> If you have a licensed copy of Winzip, you can download an command line add
> in that does that. Here is an example:
[quoted text clipped - 17 lines]
> >
> > Thx.

Reply to this Message

vseale - 30 Jun 2005 01:41 GMT

The winzip source code is open-sourced. The Access World Forum website has
instructions on how to zip files within Access. Go to
http://www.access-programmers.co.uk/forums/index.php?
and look in the Code Repository for "Zip Files Within Access"

> Thanks for that.
> If I install the WinZip add-in and then 'split' my database base, will the
[quoted text clipped - 21 lines]
> > >
> > > Thx.

Reply to this Message

Klatuu - 30 Jun 2005 14:11 GMT

You would have to include the winzip files with your distribution package.

> Thanks for that.
> If I install the WinZip add-in and then 'split' my database base, will the
[quoted text clipped - 21 lines]
> > >
> > > Thx.

Reply to this Message