problem trying to unzip from the code

  • Thread starter Thread starter ana
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WinZip automation: using wzunzip -v to extract archive content inf 5
Problem using obj.Namespace(sourceFileName) Namespace(DestinationFilename)­.Items and then opening t 1
Invoke Command Line (Shell Method with Winzip) 1
How to kill the zipped files in C:\Document and Settings\LogginName\Temp\ using code for this strang 2
run winzip in excel macro 1
Problem using obj.Namespace(sourceFileName) Namespace(DestinationFilename).Itemsand then opening th 3
Unzipping Files 4
OT? How To UnZip Via Command Line w/WinZip 11.1? 4

Back
Top