How to Launch Java Windows Application from within Excel VBA?

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
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
 
Upvote 0

Forum statistics

Threads
1,226,695
Messages
6,192,481
Members
453,727
Latest member
tuong_ng89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top