(Excel) SCP Download Files Matching a Pattern, such as *.txt

Demonstrates how to SCP download files matching a pattern, such as *.txt.

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 = "MY-SSH-SERVER-DOMAIN-OR-IP"

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("MY-SSH-LOGIN","MY-SSH-PASSWORD")
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' Once the SSH object is connected and authenticated, use it
' in the 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

scp.HeartbeatMs = 200

' Set the SyncMustMatch property to "*.pem" to download only .pem files
scp.SyncMustMatch = "*.pem"


remoteDir = "qa_syncA"

localDir = "c:/aaworkarea/scp/qa_syncA"

' Download synchronization modes:
' mode=0: Download all files
' mode=1: Download all files that do not exist on the local filesystem.
' mode=2: Download newer or non-existant files.
' mode=3: Download only newer files.  
'         If a file does not already exist on the local filesystem, it is not downloaded from the server.
' mode=5: Download only missing files or files with size differences.
' mode=6: Same as mode 5, but also download newer files.

mode = 0

' Do not recurse the remote directory tree.  Only download files matching *.pem
' from the given remote directory.

bRecurse = False

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

Debug.Print "SCP download matching success."

' Disconnect
ssh.Disconnect