nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

911999_en-US

liliconcom

Open file in excel with whitespace in filename

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.

Automation and Scripting

Re: Open file in excel with whitespace in filename

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