I am trying to run a batch file process from an application called Monarch. I have no trouble in running the below application using Shell, but when the program opens it prompts me to enter a filepath to run a .bat file, in much the same way we want to open a certain file in Excel after starting up the Excel application. I want to run the application, which I can do, but I also want vba to input the filepath into the prompt box, which looks exactly like the promt given to you by Access/Excel when open/saveas files.

My code looks like this at the moment:

Call Shell("C:\Program Files\Monarch\program\Autoscrp.exe", vbMinimizedFocus)

Please help!!

I am not sure I understand what you are trying to do here. From the title of the post it sounds like you want to run an application from Access. Then you say you are trying to run something from an application called Monarch.

I think you are saying you want to open Monarch from Access using the code below, and you want to pass a file name to the application, which your code below is not doing. You are trying to run Autoscrp.exe using Monarch, and Monarch? (Or Access?) is promtping you for a .bat file instead?



mmcdonal

Take a look at the SENDKEYS function.

It may do the trick. It has it's drawbacks but I've used it successfully in the past when I didn't have any other way to launch an application cleanly.

Regards.