Launch JMP.Application not working for JMP 11

ivanchng

Hi there,

I tried to launch Jmp using my VBA code below but it doesn't popup?

I want to launch the JMP application but failed.

I am using JMP PRO 11 with Wins7 64Bit.

Please advise.

Sub JMP_Test()

   

    Dim myJMP As JMP.Application

   

       Set myJMP = CreateObject("JMP.Application")

       myJMP.Visible = True

       DocOpen = True

       Set JMPDoc = MyJMP.OpenDocument("C:\Program Files\SAS\JMP\<versionnumber>\Samples\Data\Big Class.jmp")

       DocOpen = True

End Sub

briancorcoran

Before you can automate JMP, you must establish a reference to it.  If you are using Excel and have the "Developer" menu enabled, you need to go to Tools->References.  Within the dialog that comes up, you can select "JMP".  The pane below the selection list should have the Location: C:\Program Files\SAS\JMPPRO\11\jmp.tlb.  Once you do this, then you can start JMP up in VBA code.  If you have already done this, make sure the path to your Big Class file is correct.  For instance, if you are using JMPPro, it will be  c:\program files\sas\jmppro\11\samples\data.  Note the JMPPRO in the directory, not JMP (and a real version #).

Brian Corcoran

JMP Development