Having problem with WinZip shell commands within excel

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.