A couple of months ago I posted this question:
https://communities.sas.com/message/159304#159304
I've been working on this problem in Excel. I've automated the data retrieval from PHD, formatted the data for export to JMP. I tried to Macro Record use of the JMP Add-in to Transfer Data Table to JMP, but Excel does not appear to record any of the JMP Add-in commands. Here is the recorded Macro:
Sub JMPPush()
' ' JMPPush Macro ' '
Sheets("Export to JMP").Select
Range("B5").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
End Sub
Does anyone know how to automate the JMP Add-in via macro recording or VBA commands? Or must I code VBA to push data without use of the Add-in as described in the JMP Automation Reference? Thanks!
Received the following from JMP Support:
Good morning Mark,
Regarding your Excel add-in automation question,
currently the add-in does not support recording actions or being automated
itself. Only the JMP features, menus,
and JSL can be automated from your OLE automation application.
Cheers,
Win LeDinh
JMP Technical Support
Received the following from JMP Support:
Good morning Mark,
Regarding your Excel add-in automation question,
currently the add-in does not support recording actions or being automated
itself. Only the JMP features, menus,
and JSL can be automated from your OLE automation application.
Cheers,
Win LeDinh
JMP Technical Support