Choose Language Hide Translation Bar
Community Trekker

Clearing Data table and automatically execute JSL scripts upon file open


I'm new to JSL scripting. Current i am working on a project when i would like to open the JMP file from VBA macro. Below are the scripts which i have google'd and found.


-- VBA Scripts which will open JMP file -


Dim app As JMP.Application
Dim doc As JMP.Document
Set app = CreateObject("JMP.Application")
app.Visible = True
Set doc = app.OpenDocument("C:\Users\ABC\Desktop\")



So far, i am able to open file from VBA macro. My question is, how can i copy the data from my excel sheet into JMP each time i run it and stay at jmp file # i realized when run the script at JMP, a new data table will pop up. How can i prevent the popping out new data table where else i need to let the data remain at S1.Jmp?






Use for all sheets( 1 ),

Concatenate Worksheets( 0 ),

Create Concatenation Column( 0 ),

Worksheet Settings(


Has Column Headers( 1 ),

Number of Rows in Headers( 1 ),

Headers Start on Row( 1 ),

Data Starts on Row( 2 ),

Data Starts on Column( 1 ),

Data Ends on Row( 0 ),

Data Ends on Column( 0 ),

Replicated Spanned Rows( 1 ),

Suppress Hidden Rows( 1 ),

Suppress Hidden Columns( 1 ),

Suppress Empty Columns( 1 ),

Treat as Hierarchy( 0 )




Also, how can i automatically trigger the script with other statistical functions such as distribution plot under the same scripting?


Kindly advise how can i write a simple script to:

1.Open JMP file via VBA scripting

2.Clear file content

3.Import directly from VBA excel and stay at without the need to open another data table ( as i would like to save scripts to data table -

4. Automatically execute distribution plotting ( as example)


Steps 1 to 4, is done automatically when i hit my button at VBA excel.. it will connect to JMP and perform all the necessaries function as described above.

Many Thanks!







0 Kudos