(Excel) SFTP Download Files Matching a Pattern

Demonstrates how to download files in a directory matching one or more patterns (such as "*.zip" or "abc*_*0719.csv".

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 sftp As Chilkat.SFtp
Set sftp = Chilkat.NewSFtp


success = sftp.Connect("my-ssh-server.com",22)
If (success = True) Then
    success = sftp.AuthenticatePw("mySshLogin","mySshPassword")
End If

If (success = True) Then
    success = sftp.InitializeSftp()
End If

If (success <> True) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' The SyncTreeDownload method can be used non-recursively to download all files matching a set of patterns.

' This example will download all files, but only those files having filenames
' that match *.csv and *.eml
sftp.SyncMustMatch = "*.eml; *.gif"


remoteDir = "syncDownloadTest/someDir"

localDir = "qa_output"

' mode=0: Download all matching files according to SyncMustMatch

mode = 0

' do not recursively traverse the remote directory tree.

recursive = False

success = sftp.SyncTreeDownload(remoteDir,localDir,mode,recursive)
If (success <> True) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

Debug.Print "Success."