I am trying to use VBA code to upload a file to a SUBFOLDER on a FTP Server. I am successful when I upload directly to the ROOT of the FTP site. When I try to upload to the Subfolder, I get the message "unknown host."
My code looks like this:
strFTPServ = "ftp://destination.com/uploads"
strGet = "c:\SourceFolder\" & strFile
'Mounting file command for ftp.exe
lngNum = FreeFile()
Open PATHLOCAL & "\FtpComm.txt" For Output As #lngNum
Print #1, "user myuser mypassword"
Print #1, "bin"
Print #1, "put " & strGet ' Send File
Print #1, "close" ' close connection
Print #1, "quit" ' Quit ftp program
strShell = "ftp -i -n -s:" & PATHLOCAL & "FtpComm.txt " & strFTPServ
If I remove the /Uploads, the code works PERFECTLY. I am certain that the folder on the FTP server is called Uploads.