run winzip in excel macro

[pamela]

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]

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