log in to FTP using VBA

Question

I'm trying to access FTP using hostname, username & password. need to access the particular folders and copy the latest file to my local path.
Copying the latest file is working using the below code. Could someone probably help me to append the code with FTP login

Sub test()
Dim myFile As String, Result As String
Const TargetFolder As String = "D:\Wolken\Pending Report\Files\"
Const myPath As String = "D:\Test\"
myFile = Dir(myPath & "*.csv")
Do While myFile <> ""
If myFile > Result Then Result = myFile
myFile = Dir
Loop
FileCopy myPath & Result, TargetFolder & Result
End Sub

Answer 1

Excel development is not currently supported here on QnA. They're actively answering questions in dedicated forums here.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom
https://social.msdn.microsoft.com/Forums/Lync/en-US/home?forum=exceldev

--please don't forget to Accept as answer if the reply is helpful--