View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 168
Default RUNNING WINZIP32 FROM EXCEL

Thanks Dave,

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

Thanks again.
Paul

"Dave Peterson" wrote in message
...
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