(Excel) Synchronize Remote Directory Tree

Uploads a directory tree from the local filesystem to the FTP server. Synchronization modes include:

mode=0: Upload all files
mode=1: Upload all files that do not exist on the FTP server.
mode=2: Upload newer or non-existant files.
mode=3: Upload only newer files. If a file does not already exist on the FTP server, it is not uploaded.

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 ftp As Chilkat.Ftp2
Set ftp = Chilkat.NewFtp2

ftp.Hostname = "ftp.example.com"
ftp.Username = "login"
ftp.Password = "password"

ftp.KeepSessionLog = True

' Connect and login to the FTP server.

success = ftp.Connect()
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

' Set the current remote directory to the root of
' the tree where files are uploaded.
success = ftp.ChangeRemoteDir("/abc123")
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

' Recursively upload all non-existant and newer files.

mode = 2
success = ftp.SyncRemoteTree("c:/temp/abc123",mode)
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

success = ftp.Disconnect()

' Display the session log.  
Debug.Print ftp.SessionLog