You can script the JMP Profiler interface to Microsoft Excel, although not the Transfer to JMP interface. Here is the basic syntax:
excel_obj = Excel Profiler(
Workbook( "excel_workbook_path" ),
Model( "name_of_model" )
);
The Model argument is optional. If you supply only the workbook, you are prompted to select the model. You do not need to specify the worksheet, because the model is found no matter where it is located.
Once you have an Microsoft Excel Profiler object, you can send the following messages to run the JMP prediction profiler using the Microsoft Excel model. For example:
excel_obj <<Prediction Profiler( 1 );