cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
lwx228
Level VIII

How to run jsl script in excel VBA?

My JMP installation path is "c:\00\jmp\jmp.exe".


I need to start jMP.exe in a VBA and have "jMP.exe" run the "c:\abc.jsl" file.

I wrote VBA like this.The JMP program can be started, but JSL is not running.

Sub test()

    Shell "c:\00\jmp\jmp.exe ""c:\abc.jsl"""

End Sub

2020-06-29_17-50.png

16 REPLIES 16
lwx228
Level VIII

Re: How to run jsl script in excel VBA?

I'm going to do it by default.
How should I set it up?

Thank Georg!

2020-06-30_22-37.png

 

nascif_jmp
Level VI

Re: How to run jsl script in excel VBA?

@lwx228 Also which OS and version of JMP you are using?

 
lwx228
Level VIII

Re: How to run jsl script in excel VBA?

win 7 64b
JMP pro 14.3

Thank nascif!
nascif_jmp
Level VI

Re: How to run jsl script in excel VBA?

I can't reproduce the issue you are having on my environment. The exported .CSV looks fine.

I'd recommend trying out a newer version of JMP, or if you can't upgrade, reach out to tech support.

Looks like you are very close, though.

 
lwx228
Level VIII

Re: How to run jsl script in excel VBA?

This is also the case with CSV exported using JMP Pro version 15.1.

Thanks!
lwx228
Level VIII

Re: How to run jsl script in excel VBA?

Got it. It has to do with the default language choose.An error occurs when the column name is not in English.

 

2020-07-02_08-06.png

nascif_jmp
Level VI

Re: How to run jsl script in excel VBA?

Nice! Glad you found it.