Executing file from Office sharepoint directly

[#1]

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_...");

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

[#2 · Accepted solution]

Hi @Ole,

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

Open microsoft office 365 cloud-based excel from JMP/JSL? 

How to extract data from an Excel file on Sharepoint? 

[#3]

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.