I have a java app that runs from a command line. I need to be able to call it in VBA.
I have code that populates a table and then exports that table to a CSV file. I then go manually run the java app on a command line using the new csv file as one of the runline parameters i.e. 'CalculateValues myNewInputFile.csv myNewOutputFile.csv' the app creates an output file call myNewOutputFile.csv.
I would like to automate this so that I dont have to go out and manually run the java app each time.