UltimateZip (.4KB download) is free and has a batch compressor.
Batch Compressor,compresses individual files to individual archives.
http://www.ultimatezip.com/

I have Ultimate Zip installed but I only use the right click menus and can't
find the actual executable at the moment you won't have any trouble
finding it if you install.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Darren Hill" wrote in message ...
Thanks for that reference. In the thread it mentions:
============
With the shareware command line zip utility from the PKWARE web site

http://www.pkware.com/shareware/pkzipc40.html

it's easy to create a zip file using Shell:

Shell "pkzipc -add e:\zipfile @e:\list.txt"
============
Unfortunately, that's a dead link. Does anyone know where hat utility can be
found, or one like it?

--
Darren

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Not without a great deal of work, which may be worthwhile if you have to
do
this often. See this thread for some ideas:

http://google.com/groups?threadm=epq...%40tkmsftngp07

--

Vasant

"Darren Hill" wrote in message
...
Is it possible to use Excel to take all Excel files in directory, open
winzip and zip them all in individual zip files with the same name as
the
Excel files?


Darren