Run VBA code in JSL script

[#1]

Hello all!

I'm new to JMP. I've seen many post claiming that it is possible to run a JSL script via Excel VBA. I was wondering if the other way around is possible. Run VBA code inside a JSL script. Reason: I have a macro in Excel and a script in JMP. I would have liked to bring the excel macro to my JMP script. Thanks for info!

[#2]

check out this link for basic details:

https://support.sas.com/documentation/onlinedoc/jmp/13.1/AutomationReference.pdf

page 35 has an example of automating JMP from Excel.

[#3 · Accepted solution]

You can run a VBScript (which is a subset of VBA and can be used to automate Excel) using JSL's RunProgram.
See my response to this previous community discussion for more details: https://community.jmp.com/t5/Discussions/JSL-Open-a-VBS-script/m-p/36336/highlight/true#M21350