(Excel) FTP Iterate over Files in Directory Matching ListPattern

See more RSA Examples

Uses the ListPattern property to iterate over the files in a directory matching the pattern.

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 = "my_login"
ftp.Password = "my_password"
ftp.Port = 21
ftp.AuthTls = True


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

' Change to the "images" sub-directory located under our FTP account's home directory.
success = ftp.ChangeRemoteDir("images")
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

ftp.ListPattern = "*.png"

' Fetch the current remote directory contents by calling GetDirCount

n = ftp.GetDirCount()
If (n < 0) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If


i = 0

Dim sbLocalPath As Chilkat.StringBuilder
Set sbLocalPath = Chilkat.NewStringBuilder

Do While i < n
    filename = ftp.GetFilename(i)
    Debug.Print filename

    ' Download this file.
    Dim success As Boolean
    success = sbLocalPath.SetString("qa_output/")
    success = sbLocalPath.Append(filename)
    success = ftp.GetFile(filename,sbLocalPath.GetAsString())
    If (success <> True) Then
        Debug.Print ftp.LastErrorText
        Exit Sub
    End If

    i = i + 1
Loop