Saving file to compressed folder
 

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

Saving file to compressed folder
 

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

Saving file to compressed folder
 

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


.