I’m trying to find ways to share a shortcut to a file (Excel Add-In) I have stored in MS Teams/Sharepoint.
So far I’ve gotten it to work via “Sync/Shortcut” and by opening the files in explorer and creating a shortcut then copying it.
I looked into opening files via “File Explorer” without using a shortcut/sync feature by using “Classic Mode” in IE to open files, but I noticed that FE wasn’t able to get back to the FE URL unless the user has first opened it via IE and even then, it must be done each restart of the computer! So, that method seems out unless somebody knows a fix for that.
I tried using:
start "" "%systemroot%explorer.exe" "\domain.sharepoint.com@SSLDavWWWRootsites..."
Today I resigned to at least get it working, and setup instructions on how to use “Sync” which is the reccomended method by microsoft, but then I found when I tried to hyperlink the “deploy” script, that MS Word doesn’t allow Environment Variables (
%USERPROFILE%Sharepoint...) inside Hyperlinks in a word document!
Now I’m wondering if there is a way I can prevent users from accessing/downloading files unless access via “Sync”, but I don’t like how “Sync” doesn’t make a shortcut under File Explorers “One Drive”.
I see now that if I add a shortcut AFTER sync, it won’t place a shortcut under “One Drive” in FE, but I’m wondering if I add a shortcut, then sync, do I get the benefits of Sync and it’s under File Explorer? Note: I just tried to sync after shortcut and it says “You’re already syncing a shortcut tot a folder from this shared library”.
As it stands now, I think I’ll direct users to hit “Add a Shortcut”, then navigate via “File Explorer” as I can’t use Hyperlinks still to reference “One Drive” in the MS Word document that details this process and then create the shortcut/run the deploy script.
Does anybody have suggestions on a best approach for this?