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

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

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

Use VBA to create a .bat file and then exectue the .bat file
--
Gary''s Student - gsnu2007b


"Mac Lingo" wrote:

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

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

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.



--

Regards,
Nigel




"Mac Lingo" wrote in message
et...
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