BookmarkSubscribeRSS Feed

Community Trekker


Jun 23, 2011

Excel sheet dynamically linked to data table.

Hello jmpers,
Can somebody help ? I have difficulties in building a control chart
I am trying to make a control chart which changes dynamically, for that I need that the data in my data table will change whenever the user changes a value in excel
Does someone knows how to link the excel sheet to data table dynamically?

There is an example of what I need to accomplish but this example is a simulation, in the real control chart I need to get the values from excel

Tanks a lot Pniel




Jun 23, 2011

Re: Excel sheet dynamically linked to data table.

I don't know the details but I think the best chance of success is to add a VB script to the Excel file that adds a row to the JMP data table whenever the value changes. Many JMP actions can be driven via OLE Automation.