View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kevin Beckham Kevin Beckham is offline
external usenet poster
 
Posts: 78
Default Calling WinZip from Excel

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
.