FTP FILE TRANSFER PROTOCOL FROM VBA?

[jari toukkari]

Hi gurus

An Excel file is saved as .csv and that should be send using ftp to a
certain address. Possible? How?

I tried this simply by save-as to an IP address, but it stopped the
receiving server and I don't want to test that again ;-)

Cheers, Jari T

 

[TroyW]

Here are a couple of ideas.

SAMPLE: VBFTP.EXE: Implementing FTP Using WinInet API from VB
http://support.microsoft.com/default.aspx?scid=kb;en-us;175179


If you look at all of the available controls that are in the Userform
Toolbox or Control Toolbox toolbar you may find: "Microsoft Internet
Transfer Control". (I know it's included with the Developer Version of MS
Office, maybe standard Office too?) It is an ActiveX control of the WinInet
API listed above.

Troy