Open Excel File in Excel (Windows standard application) by JSL

Question

Dear all,

my JMP should host a toolbox with also Excel and other files,

so I need to open a file by another application from my Windows system (JMP Pro 15.1, Win10).

Most preferably I would use that standard application that is used by windows explorer, when opening a file.

The example below opens the xls in JMP, I would like to open it in Excel, does anyone know how to accomplish that?

Thanks in advance!

Names Default To Here( 1 );

cdt = Open( "$SAMPLE_DATA\Big Class.jmp" );
xls_path = Convert File Path( "$TEMP\Big Class.xls" );
cdt << save as( "$TEMP\Big Class.xls" );

// open file in Excel application, not in JMP, how to ?
open(xls_path, /*Excel Wizard*/);

Mauro_Gerber · Accepted Answer

Be aware to avoid spaces in the file name, otherwise the argument must include "path" in the string (so double")

Names Default To Here( 1 );

cdt = Open( "$SAMPLE_DATA\Big Class.jmp" );
xls_path = Convert File Path( "$TEMP\Big_Class.xls" );
cdt << save as( "$TEMP\Big_Class.xls" );

RP = Run Program(
	Executable( "C:\Program Files (x86)\Microsoft Office\Office15\excel.exe"/*path to excel, you may search it in the registration entry of microsoft*/ ),
	Options( {"/r",SUBSTR(xls_path,2)} ),
);

txnelson · Accepted Answer

Using the Web() function is a quick and easy way to open an external file in it's assigned application

Names Default To Here( 1 );

cdt = Open( "$SAMPLE_DATA\Big Class.jmp" );
xls_path = Convert File Path( "$TEMP\Big Class.xls" );
cdt << save as( "$TEMP\Big Class.xls" );

web("$TEMP\Big Class.xls");