This might help. Not sure.
http://www.kayodeok.btinternet.co.uk...excelhowto.htm
Scroll down to:
How to Open Documents from FTP Site and Save Documents to FTP Site with an
Office XP Program
"Mac Lingo" wrote:
I want to run "ftp" from VBA Excel. That means starting the program,
executing commands, and getting back the output of the FTP program into VBA
for analysis. I can issue all the commands I need if I'm in the "CMD"
window, but I don't know how to connect it to VBA.
Anyone have any ideas of how to do that?
Mac
Berkeley, CA