cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Eduardo
Level III

Run VBA code in JSL script

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

Re: Run VBA code in JSL script

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

Re: Run VBA code in JSL script

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)

Re: Run VBA code in JSL script

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

Recommended Articles