View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
TroyW[_2_] TroyW[_2_] is offline
external usenet poster
 
Posts: 94
Default FTP FILE TRANSFER PROTOCOL FROM VBA?

Here are a couple of ideas.

SAMPLE: VBFTP.EXE: Implementing FTP Using WinInet API from VB
http://support.microsoft.com/default...b;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

"jari toukkari" wrote in message
...
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