Run another software program programmatically?

[Hap]

The USGS has a .jar program used to provide earthquake hazard data giving lat and long coordinates. The program also has an option to import and export an .xls batch file.

Is it "possible" to programmatically open, run, send a batch file, return the batch file, and close the program all in VBA?

Thank you

 

[Hap]

I appreciate the effort anyway. The other problem I see is the process still appears in Task Manager even after the java program is closed. I'm not sure what I can do programmatically to resolve this. If I had run any instance anytime during the day then your code would immediately recognize a process that was already running even if the program isn't open and has focus.

That would be ideal, if I could find a way to know when the program was waiting for user input. I've also had trouble with the AppActivate method. I was trying to insure that the program had focus so my sendkeys weren't being applied to the open and active excel file. Is there another way to set the focus of a program? Sort of like a Switch To event under Task Managers Applications list (assuming this is a collection?).

Thank you