topic Re: How do I use EXCEL VBA TO AUTOMATE JMP in Discussions

How do I use EXCEL VBA TO AUTOMATE JMP

Wei1 — Fri, 09 Jun 2023 16:02:04 GMT

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.

Re: How do I use EXCEL VBA TO AUTOMATE JMP

SDF1 — Thu, 10 Nov 2022 13:48:10 GMT

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.

Re: How do I use EXCEL VBA TO AUTOMATE JMP

Mark_Bailey — Thu, 10 Nov 2022 14:50:34 GMT

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