Winzip addin within Excel 2002 command line

[jluc Mondino]

Dear all,
I am facing an issue with a vba procedure.
In this procedure I have to Zip the current workbook and some other files.

So I use the Command :

Shell "C:\Program Files\Winzip\Wzzip " & "C:\Some Path\thezippedfile.zip " &
"C\Some Path\*.*"

Where Wzzip is the addin from Winzip for commande line usage.

If I do this way I encounter an error "Path File not found"

If I use a path with no spaces, it works well, but as I don't know where the
workbook will stored, I have to take into account that the files can be
under directories with spaces and thier names.

I have search in the winzip documentation & found no information about this
issue.

If somebody could help me I will appreciate a lot.

Cheers
Jluc

 

[Word Heretic]

G'day "jluc Mondino" <[email protected]>,

"""C:\Program Files\Winzip\Wzzip """ & """C:\Some
Path\thezippedfile.zip """ & """C\Some Path\*.*"""

Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


jluc Mondino reckoned:

 

[jluc Mondino]

Thanks for your help, I will try it this evening, but I that I have already
tried this but I am not sure with the commas numbers.