topic Re: Executing file from Office sharepoint directly in Discussions

Executing file from Office sharepoint directly

Ole — Fri, 09 Jun 2023 22:09:05 GMT

Hi,

I am in progress of transferring my scripts to the companies new office 365 account. I would like to be able to access and execute the jsl's (and csv's, html,s) directly from sharepoint with a link like

include("https://company.sharepoint.com/sites/Site_Name/Shared%20Documents/General/Data_Center/01_scripts/01_xx/xx_content.jsl");

so that all jmp users can run the same script pressing a button from a journal I created.

I get an error message failed because of: Internet error 403 ...

If I try to open the link directly from JMP I get the following error message:

Is there a way to run the jsl from this link (and similarly open, save and close excel and html's)?

Thanks

Ole

Re: Executing file from Office sharepoint directly

ih — Mon, 22 Mar 2021 12:35:22 GMT

Hi @Ole,

One option is to open the page in a JMP web browser window first. Have a look at these threads:

Re: Executing file from Office sharepoint directly

Ole — Wed, 16 Jun 2021 14:00:42 GMT

Hi,

Sorry for the late reply. I changed company and as I now came into the same situation again I had to retry the fix you proposed. It took me some time but eventually got it to work. The one thing that threw me off was that I didn't run the command below first. It has only to be run one time. After that the connection between JMP and Office is established:

Web( "https://company.sharepoint.com/:x:/r/sites/Folder/filename.xlsx", JMP window );

The command

Web( "https://teams.microsoft.com", JMP window );

that was used in the embedded links doesn't work with the newest version of Office.