View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pamela pamela is offline
external usenet poster
 
Posts: 1
Default 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 .