ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   FTP FILE TRANSFER PROTOCOL FROM VBA? (https://www.excelbanter.com/excel-programming/296171-ftp-file-transfer-protocol-vba.html)

jari toukkari

FTP FILE TRANSFER PROTOCOL FROM VBA?
 
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[_2_]

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






All times are GMT +1. The time now is 08:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com