cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Wei1
Level II

How do I use EXCEL VBA TO AUTOMATE JMP

Hi All, I'd like to learn how to use Excel/VBA run JMP, could someone have simple code to show how it work.

thank you.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How do I use EXCEL VBA TO AUTOMATE JMP

Please read this section in the chapter about Extending JMP in the JMP Scripting Guide if you still need to run JMP from VBA.

View solution in original post

2 REPLIES 2
SDF1
Super User

Re: How do I use EXCEL VBA TO AUTOMATE JMP

Hi @Wei1 ,

 

  I would actually highly recommend doing the reverse -- automate it in JMP.

 

  If you have your data in Excel, it's easy to use JSL (JMP Scripting Language) to automate the process of bringing the data into JMP and then performing whatever analyses on it are necessary. And, it's probably much faster than using Excel/VBA to do it. Not to mention all of the different platforms you have available in JMP that are not there in Excel.

 

  There's plenty of online resources if you're new to JSL and need to learn it.

 

DS

Re: How do I use EXCEL VBA TO AUTOMATE JMP

Please read this section in the chapter about Extending JMP in the JMP Scripting Guide if you still need to run JMP from VBA.