(Excel) Remove a File from a .zip

Demonstrates how to remove a file from a .zip.

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, remove an entry, 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 = zip2.DeleteEntry(entry)

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

' To write to a different filename, change the FileName..
zip2.FileName = "qa_output/ac.zip"
success = zip2.WriteZipAndClose()

Debug.Print "success."