Posted to microsoft.public.excel.programming
|
|
RUNNING WINZIP32 FROM EXCEL
At the bottom of the zip.htm page, there's code that must be included in your
project.
Did you take a copy?
PCLIVE wrote:
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
"Ron de Bruin" wrote in message
...
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
--
Dave Peterson
|