Hi
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 - S1.jmp--
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\S1.jmp")
So far, i am able to open S1.jmp 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 # S1.jmp? 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?
JSL:
Open(
"C:\Users\ABC\Desktop\Book1.xlsm",
Worksheets("S"),
Use for all sheets( 1 ),
Concatenate Worksheets( 0 ),
Create Concatenation Column( 0 ),
Worksheet Settings(
1,
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 S1.jmp file content
3.Import directly from VBA excel and stay at S1.jmp without the need to open another data table ( as i would like to save scripts to data table - S1.jmp)
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!
jwong7
