First of all i would like to thank you for sharing your scripting findings and it helped me to be able to automate my data query process. i am using VBA-Macro excel to copy my table into JMP to perform the Weibull analysis and obtain the Scale & Shape values and copy out into my VBA -Macro excel file.Below are the code i used. Hope it will be helpful for others as well.
Sub 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\WS.jsl")
JSL scripts ( saved as WS.jsl format)
//! <<<if you want to automatically run the JSL scripts below and it must be at your 1st line in your JSL file>>>.
// To automatically copy out the Parametic Estimate data into new data table (eg: untitled.jmp format) fmrep = fm << Report; fmrep[Outline Box("Parametric Estimate ?" )][Table Box( 1 )] << make combined data table; dt1 = Current Data Table(); dt1 << SaveAs( "c:\Users\ABC\Desktop\AAA.xlsx" ); // to save the untitled.jmp file as excel file ( in this case i naed it as AAA.xlsx) at desktop location. Close( dt, No Save ); Close( dt1, No Save );
The above scripts is working perfectly for me.
Just thought to contribute back to this community with my recent finding & learning.