BookmarkSubscribe
Choose Language Hide Translation Bar
rainwang
Community Trekker

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

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!

11555_pastedImage_0.png

0 Kudos
2 REPLIES 2

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

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

11556_Capture.PNG

rainwang
Community Trekker

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

Thank you, Brian.

0 Kudos