When I try to call JMP in Excell VBA, there is always an error. Can anybody help to find what's wrong?

Question

I just put simply script here, seems i can't call the JMP application in Excel VBA. Don't know how to fix this error. Does anybody have the same error? How to fix it?

thank you!

rainwang · Answer

Thank you, Brian.

briancorcoran · Answer

In the VBA workspace, you need to add a reference to JMP.  At least in Excel 2013, in the Developer area, under Tools->References... you can add JMP.  I've attached a screenshot.

Brian Corcoran

JMP Development