Subscribe Bookmark RSS Feed

Run VBA code in JSL script

Eduardo

Occasional Contributor

Joined:

Aug 5, 2017

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!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Justin_Chilton

Joined:

Aug 27, 2015

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

 

Justin
2 REPLIES
Byron_JMP

Staff

Joined:

Apr 26, 2012

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.

Justin_Chilton

Joined:

Aug 27, 2015

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

 

Justin