(Excel) Zip -- Exclude Files Based on Wildcard Matching

Demonstrates how to use the SetExclusions method to exclude matching files from being added to a .zip.

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


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

' Let's add files from the directory tree rooted at C:\AAWorkarea\ChilkatSampleProjects

' However.. we want to exclude all files ending in ".cache" or ".pdb" regardless of the sub-directory.
' Also exclude all files under any "obj" directory,
' and we also want to exclude any .exe found under a "win10-x64" directory.

Dim saExcludes As Chilkat.StringArray
Set saExcludes = Chilkat.NewStringArray
Dim success As Boolean
success = saExcludes.Append("*.cache")
success = saExcludes.Append("*.pdb")
success = saExcludes.Append("*/obj/*")
success = saExcludes.Append("*/win10-x64/*.exe")
zip.SetExclusions saExcludes

' Append promises of paths and files to be zipped.

recurse = True
success = zip.AppendFiles("c:/AAWorkArea/ChilkatSampleProjects/*",recurse)
If (success = False) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

' Create the zip from the file and directory promises added previously.
success = zip.WriteZipAndClose()
If (success = False) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

Debug.Print "Success."