Zip a file from within VBA

[Ihar]

Hi

I need to zip a file from with in VBA and was wondering how to go about
this.

Any pointer to assist me would be greatly appreciated

 

[Stefan Hoffmann]

hi,

I need to zip a file from with in VBA and was wondering how to go about
this.

Use compressed folders, e.g.

http://www.rondebruin.nl/windowsxpzip.htm



mfG
--> stefan <--

 

[Ihar]

ty

hi,

Use compressed folders, e.g.

http://www.rondebruin.nl/windowsxpzip.htm



mfG
--> stefan <--

 

[Tony Toews [MVP]]

I need to zip a file from with in VBA and was wondering how to go about
this.

Compression DLLs, OCXs, etc
http://www.granite.ab.ca/access/compression.htm

I would not use MS compressed folders as some folks, such as me, have
those disabled.

You should be registering Winzip which costs $$$.

The Info zip DLLs mentioned on the above page work and are free. All
you need to do is drop them in the same folder as your FE.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[pddxxx]

7-zip (free - http://www.7-zip.org/ ) has a command line interface
that you can call using the VBA shell command.

Peter De Baets
http://www.peterssoftware.com

 

[daniel]

renviando

Do you use WinZip or Windows compressed folders?
Bill