Macro to Unzip an EXE file automaticly

[Guitarde]

Every month I get some Executable Zip files that contains sales datas in Excel files.

I'm trying to find a way to automaticly unzip these files into a specific directory. I'm able to run the EXE file from Excel but not able to specify the destination directory or press ALT-U to unzip it.


Sub Unzip()
Shell pathname:="c:\zip.exe", windowstyle:=shellnormfocus
SendKeys ("C:\UnzippedFiles_directory")
End Sub

Any ideas how I can take control of this Winzip window ???



<img src="http://www.sorelmetal.com/eric/zip.jpg"

 

[Guitarde]

Forget it, it's working.

It wasn't working in the step by step mode, but in real mode it's working great !

Sorry guys.