topic Re: Excel from journal in Discussions

Excel from journal

drdrf — Tue, 09 Jul 2024 23:57:49 GMT

Is there a way to link to an excel file from journal so that the link opens the excel file? I am probably missing something very obvious, but every way I have tried results in JMP trying to import the excel spreadsheet into a new JMP data table.

I am using JMP 17.

Re: Excel from journal

txnelson — Wed, 10 Jul 2024 01:00:19 GMT

Do you want to open the Excel file as a JMP data table, or do you want to open the Excel file in Excel?

Re: Excel from journal

drdrf — Wed, 10 Jul 2024 07:49:38 GMT

I want to open the file in Excel

Re: Excel from journal

jthi — Wed, 10 Jul 2024 09:00:37 GMT

One option is to use Web() command for that

Names Default To Here(1);

nw = New Window("",
	Button Box("Open",
		Web("$SAMPLE_IMPORT_DATA/Team Results.xlsx")
	)
);

nw << journal;
nw << close window;

Run Program() is a good other option but it is more complicated to use