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: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Eduardo
Eduardo
Level III

Run VBA code in JSL script

Aug 13, 2017 05:16 AM (7043 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 11:43 AM (8188 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 (6996 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 11:43 AM (8189 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