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?
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.