(Excel) FTP Connect, Examine Server Certificate, and then Authenticate

Demonstrates how to connect to an FTP server, examine the server's SSL/TLS certificate, and then, if it meets the application's security requirements, proceed to authenticate.

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes Chilkat Ftp2 to have been previously unlocked.
' See Unlock Ftp2 for sample code.

Dim ftp As Chilkat.Ftp2
Set ftp = Chilkat.NewFtp2

ftp.Hostname = "www.authtls-ftps-server.com"
ftp.Username = "FTP_LOGIN"
ftp.Password = "FTP_PASSWORD"
ftp.AuthTls = True
ftp.Port = 21

' Connect to the FTP server using explicit TLS (AUTH TLS).

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

' Get the FTP server's certificate.

Set serverCert = ftp.GetSslServerCert()
If (ftp.LastMethodSuccess <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

' Now that we have the certificate, we can check it in any way we desire.
' (See the online reference documentation for the certificate object's methods
' and properties)...

' Assuming the certificate is OK, proceed to authenticate with the FTP server.
success = ftp.LoginAfterConnectOnly()
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

' 
' Proceed with uploading/download files, etc...
' 

Dim success As Boolean
success = ftp.Disconnect()
Debug.Print "Success."