Sending Commands to other Applications (ACCESS 2000)

[GARYPSWANSON]

I am using MS Access to launch the DOS prompt using START / RUN / CMD in a Windows NT environment. Once the DOS prompt is present, is there a way to send and execute commands via the Access Macro?
<img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

[charlotte]

Are you talking about a macro or VBA code? And what are you trying to do? About all you can do at the DOS prompt from Access is run a batch file. Most things you would normally do from Access (i.e., change directory, find a file, kill a file, etc., already have command available from code to do the same thing without using the command prompt.

[GARYPSWANSON]

Charlotte,
Right now, I am using a Macro but could use VBA code as well. I am trying to launch an application that creates an MPM flat file. At the dos prompt, you would type in the command MPMRRF which starts an MPM application that creates a data file. When the data file is complete, I would return back to Access.

How would you launch the batch file from MPM after the DOS prompt is activiated?

Thanks for your help

[charlotte]

I believe you can launch them both at the same time by passing the batch file as an argument when you call the command prompt.

[GARYPSWANSON]

Charlotte,

Thanks for the advice. I will give it a try and let you know of the outcome.

Gary

<img src=/S/cool.gif border=0 alt=cool width=15 height=15>

[GARYPSWANSON]

Hi Charlotte,

I finally was able to try this, however, could not get it to work. I can start the command prompt, but seem to be unable to pass the batch file. I will try it again.

Thanks for your input.