M
MikeC
Does anyone know whether there is a way to respond to DOS *prompts* and pass
command strings to DOS from VBA? Also, is there a way to detect DOS prompt
errors and/or interrupted dialup connections from VBA?
Here's some background:
I'm developing a new application in Access 2003 that needs to do the below
in sequence.
1) Connect to a server via a direct (V.34!!!) modem connection (required by
vendor) using an existing dialup connection that has been defined in
"Network and Dialup Connections". The dialup connection contains the phone
number, user ID, password, etc. ...and yes, we actually had to *downgrade*
the modem to V.34 to be compatible. ;-D
2) Open the Command window and initiate an FTP prompt from the DOS prompt.
3) Open an IP address & port from the FTP prompt.
4) Enter a user ID and password when prompted to do so.
5) Download a file by passing a command string.
5) Exit FTP and the Command/DOS window.
6) Process the downloaded file using some existing code.
I have performed the above steps manually, so I know the command strings
required by DOS. However, I have no idea how to respond to DOS prompts from
VBA, assuming this is even possible. Does anyone have a clue?
Just in case making VBA converse with DOS wasn't sufficiently challenging,
it is also likely that I will need to detect spontaneous
errors/interruptions during a connection. This is the reason for my second
question at the top of this post. Detection of errors from within DOS
*might* be all that is needed. I'm not yet sure since I don't know whether
connection errors/interruptions will be displayed in DOS. I *think* they
will, but I'm not certain.
command strings to DOS from VBA? Also, is there a way to detect DOS prompt
errors and/or interrupted dialup connections from VBA?
Here's some background:
I'm developing a new application in Access 2003 that needs to do the below
in sequence.
1) Connect to a server via a direct (V.34!!!) modem connection (required by
vendor) using an existing dialup connection that has been defined in
"Network and Dialup Connections". The dialup connection contains the phone
number, user ID, password, etc. ...and yes, we actually had to *downgrade*
the modem to V.34 to be compatible. ;-D
2) Open the Command window and initiate an FTP prompt from the DOS prompt.
3) Open an IP address & port from the FTP prompt.
4) Enter a user ID and password when prompted to do so.
5) Download a file by passing a command string.
5) Exit FTP and the Command/DOS window.
6) Process the downloaded file using some existing code.
I have performed the above steps manually, so I know the command strings
required by DOS. However, I have no idea how to respond to DOS prompts from
VBA, assuming this is even possible. Does anyone have a clue?
Just in case making VBA converse with DOS wasn't sufficiently challenging,
it is also likely that I will need to detect spontaneous
errors/interruptions during a connection. This is the reason for my second
question at the top of this post. Detection of errors from within DOS
*might* be all that is needed. I'm not yet sure since I don't know whether
connection errors/interruptions will be displayed in DOS. I *think* they
will, but I'm not certain.