https://community.jmp.com/t5/Discussions/Transfer-data-from-Excel-VBA-to-JMP-and-get-data-back-to-VBA/m-p/350807#M60037 <P>If you are already familiar with OLE and VBA, then the <A href="https://www.jmp.com/content/dam/jmp/documents/en/support/jmp15/automation-reference.pdf" target="_self">JMP Automation Reference</A> should get you started.</P> Tue, 19 Jan 2021 11:05:19 GMT ian_jmp 2021-01-19T11:05:19Z https://community.jmp.com/t5/Discussions/Transfer-data-from-Excel-VBA-to-JMP-and-get-data-back-to-VBA/m-p/350721#M60023 <P>Hi, I'd like to describe what I need in order to have some kind of automation I'm planning.</P><P>I have a report I've already generated using Excel/VBA and I'm missing a distribution graph from JMP which is currently being made manually</P><P>And added to the report.</P><P>I'd like to know how can I send the data from Excel to JMP, generate the distribution graph and save it back to my excel sheet.</P><P>&nbsp;</P><P>To be specific, let's say I have the data for the dist. graph on my "rawData" sheet at range(A1:A1000) in excel and would like to save the dist. graph from JMP to the "DistGraph" sheet.</P><P>&nbsp;</P><P>Thanks in advance,</P><P>Liron.</P> Fri, 09 Jun 2023 22:03:36 GMT https://community.jmp.com/t5/Discussions/Transfer-data-from-Excel-VBA-to-JMP-and-get-data-back-to-VBA/m-p/350721#M60023 Lirsch 2023-06-09T22:03:36Z https://community.jmp.com/t5/Discussions/Transfer-data-from-Excel-VBA-to-JMP-and-get-data-back-to-VBA/m-p/350807#M60037 <P>If you are already familiar with OLE and VBA, then the <A href="https://www.jmp.com/content/dam/jmp/documents/en/support/jmp15/automation-reference.pdf" target="_self">JMP Automation Reference</A> should get you started.</P> Tue, 19 Jan 2021 11:05:19 GMT https://community.jmp.com/t5/Discussions/Transfer-data-from-Excel-VBA-to-JMP-and-get-data-back-to-VBA/m-p/350807#M60037 ian_jmp 2021-01-19T11:05:19Z