
Executing command line function from VBA (Excel)
Dear all,
I need to execute a command line function from VBA (Excel)
and capture results.
E.g. I need to establish FTP session and capture messages
returned in command line back to my VBA application.
Is it possible to do that?
I found one function: shell (). However it doesn't have
mechanism to capture the response messages.
Regards.
Evgeny