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

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
>
>
>

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
(E-Mail Removed)



"Mac Lingo" <(E-Mail Removed)> wrote in message
news:cxqbj.32163$(E-Mail Removed)...
>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
>