Just to add. If the FTP site is not password protected and you are
transfering a workbook, you might be able to just do a saveas. See Stephen
Bullen's comments in the thread referenced below for some information:

Comments by Stephen Bullen:

http://groups.google.com/groups?thre...%40cppssbbsa05

--
some other references:

http://support.microsoft.com/default...b;en-us;195653
SAMPLE: Using FTP WinInet APIs in Visual Basic with SimpleFtp (Q195653)

http://support.microsoft.com/default...b;en-us;175179
SAMPLE: VBFTP.EXE: Implementing FTP Using WinInet API from VB

--
Regards,
Tom Ogilvy



"Mike Archer" wrote:

Hello - Is there a way to upload files to an FTP site using VBA in an excel
macro?
--
Thanks,
Mike