(Excel) Unzip Some Files by Iterating over Entries

Demonstrates how to unzip specific files by iterating over entries in a .zip.

Download Excel Class Modules Chilkat Excel Class Modules

' This 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

' Open a .zip containing:
' 
' a1.xml
' b1.xml
' c1.xml
' dir1/a2.xml
' dir1/c2.xml
' dir2/dir3/c3.xml

' We wish to unzip only a1.xml, b1.xml, and c1.xml

success = zip.OpenZip("qa_data/zips/xml_files.zip")
If (success <> True) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

Dim sbFilename As Chilkat.StringBuilder
Set sbFilename = Chilkat.NewStringBuilder


numEntries = zip.NumEntries

i = 0
Do While i < numEntries

    Set entry = zip.GetEntryByIndex(i)


    entryFilePath = entry.FileName
    Debug.Print entryFilePath

    If (entry.IsDirectory = False) Then
        Dim success As Boolean
        success = sbFilename.SetString(entryFilePath)
        If (sbFilename.Contains("/",False) = False) Then
            ' Does not contain "/"
            ' Unzip to the qa_output directory.
            success = entry.Extract("qa_output")
            If (success = False) Then
                Debug.Print "Failed to unzip "; entryFilePath
            Else
                Debug.Print "Unzipped "; entryFilePath
            End If

        End If

    End If

    i = i + 1
Loop