Calling WinZip from Excel

[ShaneJ \(Australia\)]

Can someone please let me know if you can call WinPip from
Excel/VBA? I want to be able to zip a specified Excel
file from a macro in preparation for emailing it out.

Some example code to get me started would be great.

Thanks
Shane

 

[Kevin Beckham]

Have a look at the WinZip web site for the Command line
add-on
It's a pair of executables that allow you to call them
using the Shell command

Kevin Beckham

 

[Ron de Bruin]

Try this

http://www.rondebruin.nl/zip.htm

 

[Guest]

Thanks Kevin and Ron, that should do the trick!!

-----Original Message-----
Try this

http://www.rondebruin.nl/zip.htm

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


"ShaneJ (Australia)"


.