(Excel) How to Add a Directory Path to Files when Zipping

Demonstrates how to add a directory path to files when zipping.

For example, if files are located in directory_name:

-directory_name
--123.txt
--321.txt

The need to to create a .zip with this directory structure:

-directory_name
--123.txt
--321.txt

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim zip As Chilkat.Zip
Set zip = Chilkat.NewZip

' Intialize the zip object by calling NewZip.

success = zip.NewZip("qa_output/test.zip")

' Set a path prefix:
zip.PathPrefix = "directory_name/"

' Add references to files:

recurse = True
success = zip.AppendFiles("c:/zipTest/directory_name/*",recurse)
If (success <> True) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

success = zip.WriteZipAndClose()
If (success <> True) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

Debug.Print "success."