calling bat from VBA

[stephenaa5]

Hi, all. I have a set of JAR files that perform various functions for me. I call them by clicking a BAT file. I would like to have Access call these programs, based on some logic, but am having difficulty with the basics of launching the JAR via BAT from VBA. Here is what I have:

Shell ("C:\ProgramData\Parsimony\A\D\FMP1\run.bat")



Preeeeetty simple. I have repeatedly checked the path, and it is correct. I've copied it form "properties" just to be sure. What happens is a cmd window appears to open very quickly (barely see it) and then a whole lot of nothing. Doubleclicking run.bat executes the program just fine.

Any ideas?

Thanks, Stephen.

[June7]

Google: vba run bat

Here is one http://stackoverflow.com/questions/1...xcel-vba-macro

[fletcjas]

strXlFile = "run.bat"
strPath = "C:\ProgramData\Parsimony\A\D\FMP1"
Shell strPath & strXlFile

[Micron]

Sorry but I don't see the sense in breaking up the exact same path into variables just to piece them back together. Seems that the ending slash is missing in the path variable too.

Try a Pause command at the beginning and end of your bat file. If there is a problem in your bat file one or both of the the pauses should display an error. Without the pauses, the file can terminate before Windows has a chance to display the problem message. That presumes you're not trying to use UNC paths but are showing C: in your post.

[fletcjas]

It is because you could run the following code:

  strXlFile = "******.bat"
strPath = Left(CurrentDb.Name, Len(CurrentDb.Name) - Len(Dir(CurrentDb.Name)))
Shell strPath & strXlFile

this would run the BAT from the location of the database.