How to Launch Java Windows Application from within Excel VBA?

[CharlieNVA]

How can I launch the following command line string from within Excel?

start javaw -jar myprogram.jar" inputparamstring

I found the following link to show some promise

http://http://stackoverflow.com/questions/11343769/microsoft-excel-macro-to-run-java-program

but had trouble getting it to work fully with javaw instead of java. The java program involves a user interface and must run for an undetermined amount of time.

 

[CharlieNVA]

Problem solved. I just had to make some of my path references explicit. It can be really simple.

Code:
Sub run_mig_wizard()
Dim WshShell As Object
Dim Errorcode As Integer
Dim ShellCmd As String



ShellCmd = "C:\myfolder\Wizard\go_explicit.cmd"


Set WshShell = CreateObject("WScript.Shell")
Errorcode = WshShell.Run(ShellCmd, 3, True)
Set WshShell = Nothing




End Sub
The file go_explicit.cmd is a 2 line batch program that changes directories and runs the start javaw -jar myprogram.jar" inputparamstring, with folder paths included.

Credit for allowing me to see how simple it could be goes to BK11 whose post I read at https://social.msdn.microsoft.com/Fo...e?forum=isvvba .

If others know of more elegant ways or have their own examples on how to do this without the batch file and location dependencies please continue the post.

Thanks