cancel
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
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.