How to programmatically zip a file in VB

G

Guest

You can run an external program with the Shell function.

However if you want to zip something without opening a
window you need a program which can be run from the
command line.

If you have a registered copy of Winzip you can download a
command line add on. There used to be other zip programs
which you can use from a command line.

Shell "zipprogram.exe
arguments_to_specify_source_and_destination",
vbMinimizedNoFocus

Rod Scoullar
 
G

Greg Kraushaar

There are also free Zipper OCXs on the Web. Some of them are quite
worthwhile. Get One, register it (References!), then follow the
documentation.

Sorry. Its been a few years since I used them, so can't help you out
with sites.

Regards Greg Kraushaar
Wentworth Falls Australia
(Do not email - the reply address is a Spam spoofer)
(If you really must, remove all UCase and numbers)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA: Programmatically clear a one-key shortcut bound to a document 2
Working outlook via vba code with xlsx - error 0
Link a text box based on drop down box with four options MS Word 365 0
Active Content in this file is blocked issue 1
Problems created by Recent updates to Outlook 365 0
Remove checked items from To Do lists 0
Programmatically listing Relationships of ADP file 3
Create a dynamic master file 1

Top