(Excel) Simple FTP Download

Simple example to download a file from 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.someFtpServer.com"
ftp.Username = "myLogin"
ftp.Password = "myPassword"

' Connect and login to the FTP server.

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

' Change to the remote directory where the file is located.
' This step is only necessary if the file is not in the root directory
' for the FTP account.
success = ftp.ChangeRemoteDir("junk")
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If


localFilename = "c:/temp/hamlet.xml"

remoteFilename = "hamlet.xml"

' Download a file.
success = ftp.GetFile(remoteFilename,localFilename)
If (success <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

success = ftp.Disconnect()

Debug.Print "File Downloaded!"