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

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

-----Original Message-----
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
.

Try this

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

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


"ShaneJ (Australia)" wrote in message ...
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

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)"
wrote in message
...
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


.