Forum Discussion
Sharing a Shortcut and Hyperlink in File Explorer
Steven Andrews Thanks for the reply. I should have said we are using the SharePoint folders "Sync'ed" with via the OneDrive client, not via mapping the https address - as you said this is horribly flaky and I realise it's not really supported in a production environment.
We have these locations Sync'ed, and I need a way for our users to create and share shortcuts to these folders.
It may not be exactly what you're after but on the desktop sync, right clicking any item or folder will grant access to the Share options. It'll be indicated with the blue cloud. You can generate links for folders and items in this fashion.
I'm not terribly confident it'll be useful as each share option generates its own unique link and I'm interpreting what you're after as being similar to a unc path or somesuch.
I'll have a look on my set-up tomorrow at the office and will see if I can come up with anything more practical.
- andrewvinciAug 09, 2020Brass ContributorThis 'Share' method pushes users into a browser, and doesn't actually take them to the location in File Explorer.
Another use case for these shortcuts is file paths in shared applications: e.g. having a path built into an excel macro-based document, which multiple people use. Currently we have say
dbPath = "U:\Work\Engineering\appdb.sqlite" and multiple people interact with this excel document, and they need to have a path that is valid for everyone.- andrewvinciAug 26, 2020Brass Contributor
If anyone does come looking here, it appears there isn't a solution to this. It's currently breaking a few applications for us, and I honestly have no idea how other companies haven't had a similar issue.
Crux of it, cloud migration failed for us. Going to have to stay old-school with local files and good ol' network shares.
- alexsmith2kNov 25, 2020Copper Contributor
You can get to the folder from Windows Explorer using %userprofile%\<Company name>\<synced folder name> but Excel will not let you hyperlink to it.
We created a VBA macro that reads the reads Environ("USERPROFILE") to get the folder location and opens Windows Explorer at the project folder.
It's somewhat complicated & frustrating that you have to enable Macros on the documents but it does work!
It would be great if there was built in functionality to open a synced folder rather than a specific file, especially when trying to send links by email!