How do I start a Process I can then communicate with from VBA

[Mac Lingo]

I have an application in Excel where I execute FTP Commands in a CMD in a
Shell. This requires re-establishing the connection every time I want to
issue a new command.

Is there a way I could start a stand-alone FTP process from Excel/VBA, then
send it commands to be executed from Excel, and finally close it?

Thanks,
Mac
Berkeley, CA

 

[Gary''s Student]

Use VBA to create a .bat file and then exectue the .bat file

 

[Nigel]

I am no expert but I would investigate adding a reference to the FTP package
in the VBE and use the exposed objects for the package? I guess it depends
on the FTP package used as to what you can do.