(Excel) SCP Download/Upload Binary Files as Encoded Strings

Demonstrates how to upload and download binary files as encoded strings (base64, hex, etc.) using the SCP protocol (Secure Copy Protocol over SSH).

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 ssh As Chilkat.Ssh
Set ssh = Chilkat.NewSsh

' Hostname may be an IP address or hostname:

hostname = "www.some-ssh-server.com"

port = 22

' Connect to an SSH server:

success = ssh.Connect(hostname,port)
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' Wait a max of 5 seconds when reading responses..
ssh.IdleTimeoutMs = 5000

' Authenticate using login/password:
success = ssh.AuthenticatePw("myLogin","myPassword")
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' Once the SSH object is connected and authenticated, we use it
' in our SCP object.
Dim scp As Chilkat.Scp
Set scp = Chilkat.NewScp

success = scp.UseSsh(ssh)
If (success <> True) Then
    Debug.Print scp.LastErrorText
    Exit Sub
End If


remotePath = "images/starfish.jpg"

' Download the binary file and return as a base64 string.
' See <a href="http://www.cknotes.com/chilkat-binary-encoding-list/">List of Encodings</a> for a list of possible encodings.

encodedJpg = scp.DownloadBinaryEncoded(remotePath,"base64")
If (scp.LastMethodSuccess <> True) Then
    Debug.Print scp.LastErrorText
    Exit Sub
End If

remotePath = "images/starfish2.jpg"

' Now upload from the base64 string to the SSH server.
' Insided the call to UploadBinaryEncoded, the base64 string is decoded,
' and the decoded bytes are uploaded.  The resulting starfish2.jpg on the
' server will be identical to the original starfish.jpg
success = scp.UploadBinaryEncoded(remotePath,encodedJpg,"base64")
If (success <> True) Then
    Debug.Print scp.LastErrorText
    Exit Sub
End If

Debug.Print "SCP download/upload binary encoded success."

' Disconnect
ssh.Disconnect