(Excel) Get FTP Directory Listing as XML

Demonstrates how to call GetXmlDirListing and parse the results.

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.my-ftp-server.com"
ftp.Username = "mFtpLogin"
ftp.Password = "myFtpPassword"

' Connect to the FTP server.

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

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

' Retrieve (in XML format) the HOME directory of this FTP account.

xmlListing = ftp.GetXmlDirListing("*.*")
If (ftp.LastMethodSuccess <> True) Then
    Debug.Print ftp.LastErrorText
    Exit Sub
End If

' Now load the XML and parse it..
Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
Dim success As Boolean
success = xml.LoadXml(xmlListing)
Debug.Print xml.GetXml()

' Iterate over the XML...

i = 0

numEntries = xml.NumChildren
Do While i < numEntries

    Set xEntry = xml.GetChild(i)
    If (xEntry.TagEquals("dir") = True) Then
        Debug.Print "Directory: "; xEntry.Content
    Else

        sz = xEntry.GetChildIntValue("size")
        Debug.Print "File: "; xEntry.GetChildContent("name"); ", size: "; sz

        Set xLastMod = xEntry.FindChild("lastModTime")
        If (xEntry.LastMethodSuccess = True) Then

            month = xLastMod.GetAttrValueInt("m")

            year = xLastMod.GetAttrValueInt("y")

            day = xLastMod.GetAttrValueInt("d")
            Debug.Print "    YYYY-MM-DD: "; year; "-"; month; "-"; day

        End If

    End If

    i = i + 1
Loop

success = ftp.Disconnect()

Debug.Print "Success."

' Sample XML directory listing:
' <?xml version="1.0" encoding="utf-8" ?>
' <remoteDir>
'     <dir>Desktop</dir>
'     <dir>Documents</dir>
'     <dir>Downloads</dir>
'     <dir>Music</dir>
'     <dir>Pictures</dir>
'     <dir>Public</dir>
'     <dir>Templates</dir>
'     <dir>Videos</dir>
'     <file>
'         <name>c.py</name>
'         <size>1244</size>
'         <lastModTime full="20151009-000000" y="2015" d="9" m="10" hh="0" mm="0" ss="0" />
'     </file>
'     <file>
'         <name>cacerts_linux</name>
'         <size>177207</size>
'         <lastModTime full="20140915-000000" y="2014" d="15" m="9" hh="0" mm="0" ss="0" />
'     </file>
'     <file>
'         <name>empty.txt</name>
'         <size>0</size>
'         <lastModTime full="20150917-000000" y="2015" d="17" m="9" hh="0" mm="0" ss="0" />
'     </file>
'     <file>
'         <name>hamlet.xml</name>
'         <size>279658</size>
'         <lastModTime full="20160917-084100" y="2016" d="17" m="9" hh="8" mm="41" ss="0" />
'     </file>
' </remoteDir>
' 
'