How to call a Java program in excel VBA Macro

[Bhavani]

I want to call a java program (Forecasting models like ARIMA & Neural Networks) in excel VBA Macro.
Excel VBA Macro code for Exponential Smoothing is available and the code will run run first then the VBA code should invoke the java program and does other Forecasting models and then get entire results in Excel as output.
Can any one help in calling a java code from excel with some example (A sample program - may not be related to forecasting) is much appreciated.

Regards
Bhavani

 

[John_w]

Have a look at the VBA Shell function. Or the Wscript Shell Run or Exec methods.