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!
