(Excel) Use Explicit FTP over TLS

Demonstrates how to connect to an FTP server using explicit FTP over TLS.

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.your-ftp-server.com"
ftp.Username = "ftpAccountLogin"
ftp.Password = "ftpAccountPassword"

' Indicate that the "AUTH TLS" command should be use to convert the connection to TLS
' after the initial TCP connection to port 21 is established.
ftp.AuthTls = True

' Connect and convert the connection to TLS automatically.

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

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

Debug.Print "TLS connection established and successfully authenticated."