View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default RUNNING WINZIP32 FROM EXCEL

Hi Chip and Mike

I have example code on my site

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


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



"Chip Pearson" wrote in message ...
As far as I know, WinZip doesn't support any type of automation beyond startup switches in the command line. Open WinZip's help
file and look for "command line" or "startup switches" or something similar.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Mike215" wrote in message ...
Hi
and thanks in advance

I need to zip up all the files in 50 plus directories. I
can open WINZIP32 but how do I pass it parameters?
TID = SHELL("WINZIP32.EXE",1) gets the program up and
running but it doesn't do anything. How do I tell it what
to zip?

Mike