(Excel) Delete FTP Directory Tree

Delete an entire directory tree on an FTP server.

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.yourftpserver.com"
ftp.Username = "****"
ftp.Password = "****"

' 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 to be deleted
success = ftp.ChangeRemoteDir("/something")
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

' Delete the entire tree.  All sub-directories and files are deleted.
success = ftp.DeleteTree()
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

' The /something directory still exists.  To delete it,
' we move up one directory level and then delete it.
success = ftp.ChangeRemoteDir("..")
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

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

success = ftp.Disconnect()