Winzip using VBA - add file to zip subfolder

[TomPC]

Hi all

This is really a DOS/Command Line/Shell question but it's being run out of VBA and I know this forum better than any other.

I need to add a file to a zip file. I have working code that does this using SHELL() the below:

"C:\Program Files\Winzip\winzip32" -min -a "C:\tmp\testfile.zip" "C:\style\styles.xml"

The problem is I need to add the file 'styles.xml' to a folder in 'testfile.zip' called 'xl'. The above code only adds it to the root of testfile.zip.

Anyone know how to amend my command line script?

Thanks

Tom

 

[Leith Ross]

Hello TomPC,

You need to include the -p and/or the -r options. The former option will list the complete path while the latter option will display only the file and any subfolders in the folder where the file is located.

Remember any file names with spaces must include the beginning and ending quotes.

Filename = "C:\MyFile.zip"
Filename = """C:\My File.zip"""
​

Shell "C:\Program Files\WinZip\WinZip32.exe -min -a -p " & ZipFile & " " & Filename