390252_en-US

liliconcom

Can JMP launch an excel.xlsm file?

Is JMP jsl able to "launch" an Excel .xlsm (macro'ed) file, such that it essentially "double clicks" the file to open it and does not try to import it?

 

I am using an Excel macro for database extraction because it is 100X faster than the JMP ODBC extraction tool and would like my jsl code to run the macro'ed file.

 

Thanks in advance!

ScriptingRe: Can JMP launch an excel.xlsm file?

See the function

in the Scripting Index

Re: Can JMP launch an excel.xlsm file?

Thanks @txnelson , but I am not sure this is the answer.  If I do not know where the "Excel.exe:" is kept on someone else's computer, how can I share my script with others?

Re: Can JMP launch an excel.xlsm file?

If you know everyone is on windows or has Powershell installed you can use Run Program to open the file using the default program defined by the OS:

 

Open a file in the operating system default program 

Re: Can JMP launch an excel.xlsm file?

Let's say I want to open a file called "Test.xlsx" that is located at "C:\Users\Me\Desktop\".  What would the code look like?

 

I have tried the following but it does not seem to work:

rp0 = Run Program(
 Executable( "Excel.EXE" ),
 Options("C:\Users\Me\Desktop\test"),
 Read Function("text")
);