Macro to move a file from desktop to an FTP folder

Hi Nicole,
I've not tried this myself with vba but one way is to use a vba Shell command to execute a command just as you would from a dos window. Some code has been published here (follow the link in post #2):
http://www.mrexcel.com/forum/showthread.php?t=484879
But I've seen simpler examples (maybe I can find one later tonight).

For what its worth, you can use windows explorer as an FTP tool - just fire it up and, instead of My Documents or Desktop, type your ftp address into windows explorer: ftp://mysite.com You'll be prompted for a user name and password and then you can drag and drop files to transfer them to/from your pc to the remote directory. Be aware that the FTP protocol does not encrypt passwords, which travel as plain text. Perhaps you need the script but you can't get much simpler than this.

ξ

Edit:
Okay, here was another link:
http://www.mrexcel.com/forum/showthread.php?t=8084
In this case, Colo is using a batch file which is basically just a text file with a series of commands to be executed at the FTP prompt. I'm sure I've seen other sorts of examples though. Darned if I don't save these somewhere. Personally I use Filezilla, which I prefer since I can use it to transfer files securely (i.e., with encryption) - but I've never automated it.

Okay,
I gave it a go myself using code similar to what Colo posted, with success. My steps were:

1) Created a text file to be uploaded called C:\Test\somefile.txt
2) Created a batch file call C:\Test\testftp.bat
3) ran a shell command from VBA

the batch file listed the ftp commands, and in short was just a simple text file like this:
open mysite.com
username
password
send C:\Test\somefile.txt
bye

the vba shell command to execute the batch file (and, BTW, launch the ftp program) was simply:

You may want to open up a dos prompt and type ftp to get to an ftp prompt - you should be able to execute the very same commands from your .bat file, verbatim. But you'll get some messages if anything goes wrong. Note that this is a good reminder that the vba will execute without any warnings or errors even if it fails - so it can be a little trying at first and also may not guarantee success. It will also execute asynchronously so your VBA will not "wait" for the transfer to finish, but will continue on executing your vba even if the FTP program is not finished with the transfer. We've got a very simple implementation here.

As a footnote, (it probably doesn't apply to you as you're probably already using FTP outside of VBA) -- some computers, firewalls, or group policies will block ftp traffic.