This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
Eduardo
Eduardo
Level III

Run VBA code in JSL script

Aug 13, 2017 05:16 AM (6386 views)

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!

 

 

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Justin_Chilton
Staff Justin_Chilton
Staff
Solution

Re: Run VBA code in JSL script

Created: Aug 16, 2017 02:42 PM  |  Last Modified: Aug 16, 2017 02:43 PM (7531 views)  |  Posted in reply to message from Eduardo 08-13-2017

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

View solution in original post

2 REPLIES 2
Byron_JMP
Staff Byron_JMP
Staff

Re: Run VBA code in JSL script

Aug 16, 2017 01:54 PM (6339 views)  |  Posted in reply to message from Eduardo 08-13-2017

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.

JMP Systems Engineer, Health and Life Sciences (Pharma)
0 Kudos
Justin_Chilton
Staff Justin_Chilton
Staff
Solution

Re: Run VBA code in JSL script

Created: Aug 16, 2017 02:42 PM  |  Last Modified: Aug 16, 2017 02:43 PM (7532 views)  |  Posted in reply to message from Eduardo 08-13-2017

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