(Excel) Replace/Update a FIle in a .zip

Demonstrates how to replace/update a file from a .zip. Note: This requires the entire .zip to be rewritten.

Download Excel Class Modules Chilkat Excel Class Modules

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

' First prepare a .zip and write it..
Dim zip As Chilkat.Zip
Set zip = Chilkat.NewZip

Dim success As Boolean
success = zip.NewZip("qa_output/abc.zip")

' Add some files..

Set entry = zip.AppendString("a.txt","aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa")

Set entry = zip.AppendString("b.txt","bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb")

Set entry = zip.AppendString("c.txt","cccccccccccccccccccccccccccccccccccc")

' Write to qa_output/abc.zip
' This .zip contains three files: a.txt, b.txt, and c.txt
success = zip.WriteZipAndClose()

' -------------------------------------------------------------------
' Open abc.zip, replace the content of the "b.txt" entry with something else, and re-write.
Dim zip2 As Chilkat.Zip
Set zip2 = Chilkat.NewZip
success = zip2.OpenZip("qa_output/abc.zip")

Set entry = zip2.GetEntryByName("b.txt")
success = entry.ReplaceString("This is the new content.  bbbbbbbbbbbbbbbbbbbbbb","utf-8")

' Write the modified .zip back to "abc.zip"
success = zip2.WriteZipAndClose()

Debug.Print "success."