(Excel) SFTP Resume Download

Demonstrates how to resume an SFTP download from a previous partial download.

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim sftp As Chilkat.SFtp
Set sftp = Chilkat.NewSFtp

' Set some timeouts, in milliseconds:
sftp.ConnectTimeoutMs = 5000
sftp.IdleTimeoutMs = 10000

' Connect to the SSH server.  
' The standard SSH port = 22
' The hostname may be a hostname or IP address.

hostname = "sftp.example.com"

port = 22

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

' Authenticate with the SSH server.  Chilkat SFTP supports
' both password-based authenication as well as public-key
' authentication.  This example uses password authenication.
success = sftp.AuthenticatePw("myLogin","myPassword")
If (success <> True) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' After authenticating, the SFTP subsystem must be initialized:
success = sftp.InitializeSftp()
If (success <> True) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' Download the file:

localFilePath = "c:/temp/hamlet.xml"
remoteFilePath = "subdir1/subdir2/hamlet.xml"
' The ResumeDownloadFileByName method will check
' the local file and begin downloading the remote file
' at the appropriate point.  For example, if the local
' file is already 215624 bytes long, it will begin downloading
' the remote file at the 215625'th byte -- appending to
' the local file.
success = sftp.ResumeDownloadFileByName(remoteFilePath,localFilePath)
If (success <> True) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

Debug.Print "Success."