run winzip in excel macro
 

Hi there ,

I need to run winzip to unzip files in office xp macro .

My winzip command is
"c:\program files\winzip\winzip32.exe" -min -e "c:\mydir\a1.zip"
"c:\mydir\a1.zip.1"

I can run this command directly from command line,but when I run the macro,
using shell to run winzip ,vba keeps telling me "winzip parameter validation
error"

Can anybody help me ? What is the problem there ?

any messages from you will be appreciated.

thanks in advance .

run winzip in excel macro
 

Maybe you could compare the way Ron de Bruin does it:
http://www.rondebruin.nl/tips.htm

(Look for Zip)

pamela wrote:

Hi there ,

I need to run winzip to unzip files in office xp macro .

My winzip command is
"c:\program files\winzip\winzip32.exe" -min -e "c:\mydir\a1.zip"
"c:\mydir\a1.zip.1"

I can run this command directly from command line,but when I run the macro,
using shell to run winzip ,vba keeps telling me "winzip parameter validation
error"

Can anybody help me ? What is the problem there ?

any messages from you will be appreciated.

thanks in advance .

--

Dave Peterson