topic Re: Run VBA code in JSL script in Discussions

Run VBA code in JSL script

Eduardo — Sun, 13 Aug 2017 09:16:05 GMT

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!

Re: Run VBA code in JSL script

Byron_JMP — Wed, 16 Aug 2017 17:54:33 GMT

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.

Re: Run VBA code in JSL script

Justin_Chilton — Wed, 16 Aug 2017 18:43:17 GMT

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