RUNNING WINZIP32 FROM EXCEL

  • Thread starter Thread starter Mike215
  • Start date Start date
M

Mike215

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
 
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
 
Ron,

I've tried using the the example on your website, but it seems to get stuck
at "ShellAndWait". It gives me a 'Compile error...Sub or Function not
defined'.

Do you have any insight on this?

Thanks,
Paul
 
At the bottom of the zip.htm page, there's code that must be included in your
project.

Did you take a copy?
 
Thanks Dave,

I missed that part. I guess I should have read through the whole thing.
It works now.

Thanks again.
Paul
 
Back
Top