Open file in excel with whitespace in filename

[#1]

Hi,

Is it possible to open an Excel file from JMP where there is whitespace in the filename or path?

Code from this post works where there is no whitespace:

Solved: Open Excel File in Excel (Windows standard application) by JSL - JMP User Community

excel_file_to_open = Concat( "/X:/folder location/",excel_file_new_name);

RP = Run Program(

Executable( "C:\Program Files\Microsoft Office\root\Office16\excel.exe" ),

Options( {"/r",SUBSTR(excel_file_to_open,2)} )

);

Unfortunately I can't use web() to open the file as this seems to be clashing with another application and causing an error.

Any help appreciated.

[#2 · Accepted solution]

Something like this might work (convert file path + escaped quotes)

Names Default To Here(1);

excel_file_to_open = Convert File Path("$DOWNLOADS\New folder (3)\sauna2.xlsx", "windows");

RP = Run Program(
	Executable("C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE"),
	Options( {"/r","\!""||excel_file_to_open|| "\!""} )
);

[#3]

Thanks for your help