(Excel) Create Zip in a BinData Object

Recursively appends files in a directory tree and writes a zip archive into a Chilkat BinData object.

Download Excel Class Modules Chilkat Excel Class Modules

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

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

' Initialize the zip object.  Because we will never actually write a zip file to the filesystem,
' the filepath passed to NewZip does not matter.

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

' Append a directory tree.  The call to AppendFiles does
' not read the file contents or append them to the zip
' object in memory.  It simply appends references
' to the files so that when WriteBd, WriteZip, or WriteZipAndClose 
' is called, the referenced files are streamed and compressed
' into the .zip output file (or BinData object).


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

' Write the zip archive into the bdZip object.
Dim bdZip As Chilkat.BinData
Set bdZip = Chilkat.NewBinData
success = zip.WriteBd(bdZip)
If (success <> True) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

' We could directly access the bytes of the zip archive, or perhaps
' get the zip bytes in base64 format.

zipAsBase64 = bdZip.GetEncoded("base64")
Debug.Print zipAsBase64

' Or the zip can be used by some other Chilkat method call that accepts
' a BinData object as an argument.