FTP uploading

[Mike Archer]

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

[mudraker]

Mike

This link supplys details of how a person does it from Access. It looks like it will work from with Excel

http://www.tek-tips.com/faqs.cfm?fid=5904

[Tom Ogilvy]

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