Subscribe Bookmark RSS Feed

Automating the JMP Excel Add-in

markschahl

Community Trekker

Joined:

Jun 18, 2012

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!

1 ACCEPTED SOLUTION

Accepted Solutions
markschahl

Community Trekker

Joined:

Jun 18, 2012

Solution

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

1 REPLY
markschahl

Community Trekker

Joined:

Jun 18, 2012

Solution

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