topic Re: Open file in excel with whitespace in filename in Discussions

Open file in excel with whitespace in filename

anna_717 — Fri, 07 Nov 2025 09:11:31 GMT

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.

Re: Open file in excel with whitespace in filename

jthi — Fri, 07 Nov 2025 10:14:31 GMT

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|| "\!""} )
);

Re: Open file in excel with whitespace in filename

anna_717 — Fri, 07 Nov 2025 10:29:14 GMT

Thanks for your help