| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RUNNING WINZIP32 FROM EXCEL
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
RUNNING WINZIP32 FROM EXCEL
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
RUNNING WINZIP32 FROM EXCEL
Hi Mike
See http://www.planet-source-code.com/vb...=4678&lngWId=1 and the explanation at http://www.planet-source-code.com/vb...=4696&lngWId=1 HTH. Best wishes Harald "Mike215" skrev i melding ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
RUNNING WINZIP32 FROM EXCEL
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 |
|
#6
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
RUNNING WINZIP32 FROM EXCEL
Hi PCLIVE
I missed that part. I guess I should have read through the whole thing. Glad you got it working My SendMail add -in for Outlook have this option also -- Regards Ron de Bruin http://www.rondebruin.nl "PCLIVE" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running Excel from a PDA | Excel Discussion (Misc queries) | |||
| How do I keep a running 'Top five' in Excel? | Excel Worksheet Functions | |||
| Running .bat and .exe in Excel | Excel Programming | |||
| VB code needed for running newer excel version macros in older excel versions | Excel Programming | |||
| opening and running macros in an Excel file in a new instance of Excel | Excel Programming | |||
Linear Mode
