problem trying to unzip from the code

A

ana

Hi

My problem is that I have to unzip some files from the
code, I have installed winzip 9 and wzcline.exe and I try
the following sentence
Shell "C:\Program Files\winzip\wzunzip C:\test.zip
C:\TEMP\" and everything is ok , but my problems is that
I do not know the names of the files

so I need something like :

var=test.zip
Shell "C:\Program Files\winzip\wzunzip C:\(var) C:\TEMP\"
and it does not work ..... How it is possible to do it ?

thanks
ana
 
C

Chip Pearson

Ana,

Try something like

Shell "C:\Program Files\WinZip\WZUnzip C:\" & var & " C:\Temp"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top