Take a look at this answer I found here: https://stackoverflow.com/questions/44177068/unable-to-run-macro-from-java-code
You will need to write the vb script file as shown in the question, then you can call the code to run the script using a tJava or tJavaFlex if you need to run this for each row of your job.
