Having problem with WinZip shell commands within excel

Asked By Geraldine Carr 30 points N/A Posted on - 02/10/2013

HI,

I use windows 7 on my PC. I'm having problem with winzip shell commands within excel. I would like to get help with this. Please anybody step ahead to help me immediately. 

Thanks

• Status: Open
• Question Views: 742
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By John Doctorr 0 points N/A #138405

Having problem with WinZip shell commands within excel

Try swing a group of quotes on the correct facet of .Ex

\"C:\\Program Files\\Winzip\\wzzip.exe\"

 

It would look like:

lngProID = Shell(\"C:\\Program Files\\Winzip\\wzzip.exe\" & \"-v \" & \"C:\\Temp\\Junk.zip > C:\\Temp\\List.txt\")

 

I am within the middle of doing one thing terribly similar.

 

Hope this helps!

 

Try running the command directly within the electronic communication. I.e. begin > Run > cmd.exe

 

Then kind in your example i.e.

 

C:\\Program Files\\Winzip\\wzzip.exe\" & \"-v \" & \"C:\\Temp\\Junk.zip > C:\\Temp\\List.txt

 

This should show you if the procedure is fortunate.

About John Doctorr

Questions
2

Answers
31

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 03/07/2013
• Question Category: Misc Software