Having problem with WinZip shell commands within excel

Asked By 30 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #138405

Having problem with WinZip shell commands within excel

qa-featured

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.

Login/Register to Answer

Related Questions