Forum Discussion
Sharing a Shortcut and Hyperlink 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.
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.
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!
