(Excel) FTP Set Remote File Date/Time Equal to Local File's Last-Modified Date/Time

Demonstrates how to set a remote file's date/time to be equal to a local file's date/time.

Important: Not all FTP servers support the ability to set a file's date/time.

Note: This example includes a new file access method introduced in Chilkat v9.5.0.66.

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

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

' We're going to get the last-mod date/time for the local file
' "qa_data/hamlet.xml", and then set the remote "hamlet.xml" to this date/time.
Dim fac As Chilkat.FileAccess
Set fac = Chilkat.NewFileAccess

Set dt = fac.GetLastModified("qa_data/hamlet.xml")
If (fac.LastMethodSuccess <> True) Then
    Debug.Print fac.LastErrorText
    Exit Sub
End If

success = ftp.SetRemoteFileDt(dt,"hamlet.xml")
If (success <> True) Then
    Debug.Print ftp.LastErrorText

    Exit Sub
End If

Dim success As Boolean
success = ftp.Disconnect()

Debug.Print "Success."