launching a java application from VBA

[bklabel1]

How to I launch an application from VBA?

I am writing an application that converts a file with JSON into XML. I don't see an easy way to do this in VBA so I am writing a small java application. I want to know how to call it from VBA. The application deletes the JSON result file before running the Java script. I can tell in VBA that the Java is finished after the file exists again.

Thanks,

Kevin

 

[John_w]

The Shell function should do it:

Shell "java -jar myFile.jar -options and arguments", vbNormalFocus