<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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
