How do I use EXCEL VBA TO AUTOMATE JMP

[#1]

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.

[#2]

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

[#3 · Accepted solution]

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