Thanks Ron. Also thanks for making the code available on
your site, I will continue with winzip anyway now.

Regards,
Claude

-----Original Message-----
Hi Claude

As far as I know you can't use the Win XP zip program
with code.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Claude" wrote in
message ...
Hi all

I have come across this example code, which does
precisely what I want to do, i.e. save a file to a
zipped
folder: http://www.rondebruin.nl/zip.htm

However, since our office moved to XP, we no longer have
winzip as standard software.
Does anyone know if it is possible to save from excel to
a compressed folder, e.g. by way of FileSystemObjects or
by shell to windows explorer? Any hints to get started?
Thanks


.