Darren, just use http://www.pkware.com/ and go from there

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"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