- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
16 REPLIES 16
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to run jsl script in excel VBA?
@lwx228 Also which OS and version of JMP you are using?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to run jsl script in excel VBA?
win 7 64b
JMP pro 14.3
Thank nascif!
JMP pro 14.3
Thank nascif!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to run jsl script in excel VBA?
Created:
Jul 1, 2020 02:57 PM
| Last Modified: Jul 1, 2020 11:58 AM
(2253 views)
| Posted in reply to message from lwx228 06-30-2020
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to run jsl script in excel VBA?
This is also the case with CSV exported using JMP Pro version 15.1.
Thanks!
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to run jsl script in excel VBA?
Nice! Glad you found it.
- « Previous
-
- 1
- 2
- Next »