Automatically ZIP Excel File on saving...
 

Howdie,

I have a rather large Excel file, which will be mailed around a lot. As
such I thought it would be benefical to have the file automatically
zipped (using WINzip, if possible) everytime it is saved. ANy ideas if
this is possible, and how to do it...??

Thanks!!!

D

*** Sent via Developersdex http://www.developersdex.com ***

Automatically ZIP Excel File on saving...
 

Yes this is possible

I have code here
http://www.rondebruin.nl/zip.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Darin Kramer" wrote in message ...


Howdie,

I have a rather large Excel file, which will be mailed around a lot. As
such I thought it would be benefical to have the file automatically
zipped (using WINzip, if possible) everytime it is saved. ANy ideas if
this is possible, and how to do it...??

Thanks!!!

D

*** Sent via Developersdex http://www.developersdex.com ***