Automating FTP transfer using a macro

[marcwalsh]

We're using Excel 2007, Windows XP. We've automated publishing an HTM file to our inhouse server, but we need to FTP the file to an offsite server. Right now we're doing this with a batch file and the CMDFTP program, launching it with the Windows Task manager. But, there's a built-in delay in doing so. We would like to "push" the file via FTP to the offsite server immediately after the file is created with Excel. Is this possible?

Regards,
Marc in Chico, CA

 

[jbeaucaire]

I've never done that, but when I Googled:

Excel VBA ftp file transfer

I got 100s of ready to try sample codes and add-ins.... like this one:

FTP text file transfer