Paul_Hossler
07-11-2009, 08:58 AM
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
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