Hi All,

Using AccessXP does anyone have vba code that they would share that
would take a AnyName.PDF file and using WinZip zip it with encryption
to AnyName.zip?

thanks
bobh.

bobh wrote:
The 'shell' command runs any external app. Be aware of filenames with
path which can contain spaces - the solution is always to write code
that embeds in double quotes.

"bobh" <vulcaned (AT) yahoo (DOT) com> wrote

Winzip command line options: http://www.memecode.com/docs/winzip.html


I use the following code to set the location of the winzip program

' Get path for Zip program Check for 64bin Windows 12/17/2010

If InStr(1, Environ("CommonProgramFiles"), "(x86)") = 0 Then
' 32 bit OS
strZipPath = "c:\program files\winzip\winzip32"
Else
' 64 bit OS
strZipPath = "c:\program files (x86)\winzip\winzip32"
End If

Use Shell to call Winzip

Note: Winzip may open as an Icon at the bottom of the screen. You will need
to click on it to run.

bobh wrote :
Why would you want your app to rely on WinZip being installed. Instead
surf over to http://www.info-zip.org/ and check out Info-Zip. Info-Zip
is a Free Ware Zip / UnZip library that can be used directly from
Access programmatically. It comes as a Standard DLL that need NOT be
installed or registered. Just distribute it in the same directory as
you MDB/MDE and invoke it via VBA code.


Rdub

On Wed, 27 Apr 2011 21:23:40 -0400, Ron Weiner <NoOne (AT) NoWare (DOT) NutThing>
wrote:

Agreed. I've quite happily used this. I don't recall if it supports
encryption though and to what level.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

On Apr 27, 9:23*pm, Ron Weiner <No... (AT) NoWare (DOT) NutThing> wrote:
Here in this company WinZip is part of the standard pc configuration
so it just makes sense to use it but thanks for the pointer to another
option.
bobh.

On Apr 27, 5:17*pm, "ron paii" <n... (AT) nospam (DOT) com> wrote:
thanks for the link to the winzip command line options as I didn't
even know winzip had them as I was currently looking at the Winzip
command line add-in product ( http://www.winzip.com/prodpagecl.htm ).
bobh.