Calling WinZip from Excel

  • Thread starter ShaneJ \(Australia\)
  • Start date
S

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
 
K

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
 
Top