(Excel) Gzip Compress In Memory and Base64 Encode

Demonstrates how to Gzip compress in-memory data and then encode the compressed data to base64.

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 gzip As Chilkat.Gzip
Set gzip = Chilkat.NewGzip

' This example will load a file into the fileData object.
' Your application might load fileData from other sources..
Dim fileData As Chilkat.BinData
Set fileData = Chilkat.NewBinData

success = fileData.LoadFile("qa_data/xml/hamlet.xml")
If (success <> True) Then
    Debug.Print "Failed to load file."
    Exit Sub
End If

' In-place compress the contents of fileData
success = gzip.CompressBd(fileData)
If (success <> True) Then
    Debug.Print gzip.LastErrorText
    Exit Sub
End If

' Get the base64 encoded compressed data (in a single line).

strBase64 = fileData.GetEncoded("base64")
Debug.Print strBase64
Debug.Print "--------"

' To get the base64 in multiple lines, as it might appear in MIME,
' use "base64-mime".

strBase64MultiLine = fileData.GetEncoded("base64-mime")
Debug.Print strBase64MultiLine