(Excel) SCP Upload to a Specific Remote Directory

Demonstrates how to upload a file using the SCP protocol (Secure Copy Protocol over SSH). The file is uploaded to a specific remote directory. It can be either a path relative to the HOME directory of the SSH user account, or an absolute path on the remote filesystem. Obviously, in both cases the SSH user account must have permission to create or overwrite a file in the specified directory.

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

' Connect to an SSH server:

' Hostname may be an IP address or hostname:
hostname = "www.some-ssh-server.com"
port = 22


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
' as the underlying transport 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

' This uploads a file to the "uploads/text" directory relative to the HOME
' directory of the SSH user account.  For example, if the HOME directory is /home/chilkat,
' then this uploads to /home/chilkat/uploads/text/test.txt
' Note: The remote target directory must already exist on the SSH server.

remotePath = "uploads/text/test.txt"

localPath = "/home/bob/test.txt"
success = scp.UploadFile(localPath,remotePath)
If (success <> True) Then
    Debug.Print scp.LastErrorText
    Exit Sub
End If

' This upload fully specifies the absolute remote path.
remotePath = "/home/chilkat/junk/abc/hamlet.xml"
localPath = "/home/bob/hamlet.xml"
success = scp.UploadFile(localPath,remotePath)
If (success <> True) Then
    Debug.Print scp.LastErrorText
    Exit Sub
End If

Debug.Print "SCP upload file success."

' Disconnect
ssh.Disconnect