Solved: VBA and FTP

[Paul_Hossler]

I have a macro that makes a simple TXT file.

Instead of FTPing it manually each time to the mainframe, I'd like to polish it up and have Excel/VBA FTP it to the mainframe with no user interaction

Google finds a number of articles (mostly for MS Acess), but they all seem to write an ad hoc batch file, run it, and delete it.

It seems that there must be a more streamlined and elegant way to FTP a file from a PC to a mainframe.

Does anyone have some code to get me started?

Thanks

Paul

[Bob Phillips]

Dick has a outine at http://www.dailydoseofexcel.com/archives/2006/01/29/ftp-via-vba/. It is for pictures but should be adaptable.

[Paul_Hossler]

Dick has a outine at http://www.dailydoseofexcel.com/archives/2006/01/29/ftp-via-vba/. It is for pictures but should be adaptable.


Thanks - lots of ideas there

Will mark this 'Solved'

Paul