(Excel) Box.com Download Binary File to Memory

Retrieves the actual data of the file into a memory (not to a local file).

Download Excel Class Modules Chilkat Excel Class Modules

'  This 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

'  Provide a previously obtained OAuth2 access token.
'  See Get Box OAuth2 Access Token.
http.AuthToken = "BOX_ACCESS_TOKEN"

http.FollowRedirects = True

'  The file is specified by the file ID.
'  In this case, we're downloading a file with FILE_ID = 283371752129.
'  The general form of the URL for downloading is: https://api.box.com/2.0/files/FILE_ID/content
Dim bd As Chilkat.BinData
Set bd = Chilkat.NewBinData

success = http.DownloadBd("https://api.box.com/2.0/files/283371752129/content",bd)
If (success <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Downloaded tigers.jpeg into an object holding the binary data."

Debug.Print "Number of bytes: "; bd.NumBytes