(Excel) Download a Zip from a URL and OpenBd. (No .zip file is created)

Demonstrates how to download a .zip from a URL, opens the Zip, and gets the contents of a file. No file is ever written.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

Dim bd As Chilkat.BinData
Set bd = Chilkat.NewBinData

' This URL is valid and can be tested...

success = http.QuickGetBd("http://chilkatdownload.com/example_data/hamlet.zip",bd)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

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

' Open the zip from the bytes contained in bd.
success = zip.OpenBd(bd)
If (success = False) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

' Get the entry for the file we want..

Set entry = zip.GetEntryByName("hamlet.xml")
If (zip.LastMethodSuccess <> True) Then
    Debug.Print zip.LastErrorText
    Exit Sub
End If

' Convert all line endings to CRLF (if needed)

lineEndingBehavior = 2

xmlStr = entry.UnzipToString(lineEndingBehavior,"utf-8")
If (entry.LastMethodSuccess <> True) Then
    Debug.Print entry.LastErrorText

    Exit Sub
End If

' The XML in this case is about 274K, so let's just examine the last 20 lines...
Dim sb As Chilkat.StringBuilder
Set sb = Chilkat.NewStringBuilder
Dim success As Boolean
success = sb.Append(xmlStr)

Debug.Print sb.LastNLines(20,True)