Winzip Command Line

[gravyboy]

I have the Beta of the Winzip Command Line thingy. My question is this...

If I type the following in the in Start,Run

"C:\Program Files\WinZip\WZZIP.EXE" -a zippy @listfile.txt

it works BUT when I try to 'shell' it from vb with

Shell "'C:\Program Files\WinZip\WZZIP.EXE'" & "-a zippy @listfile.txt"

it doesn't. Why?

[Joacim Andersson]

Try shelling it like this instead:

Shell """C:\Program Files\WinZip\WZZIP.EXE"" " & "-a zippy @listfile.txt"

Good luck!

[Mark Sreeves]

or like this

Dim strTemp as String
strTemp = "C:\Program Files\WinZip\WZZIP.EXE -a zippy @listfile.txt"

Shell strTemp

[Joacim Andersson]

I'm sorry mark but you have to use quotes around the path because there are spaces in it.

Dim strTemp as String
strTemp = """C:\Program Files\WinZip\WZZIP.EXE"" -a zippy @listfile.txt"

Shell strTemp

[Mark Sreeves]

Whoops!
Sorry about that slight oversight on my part

But I meant use a variable so you can see exactly what is being passed to shell()

[gravyboy]

Big thanks to everyone! I should have thought of it myself-I use similar structure when contructing SQL strings to open recordsets! Joacim's suggestion was bob on.