- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Excel from journal
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.
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Excel from journal
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
-Jarmo
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Excel from journal
Do you want to open the Excel file as a JMP data table, or do you want to open the Excel file in Excel?
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Excel from journal
I want to open the file in Excel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Excel from journal
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
-Jarmo