Last active
June 2, 2025 13:41
-
-
Save guwidoe/6f0cbcd22850a360c623f235edd2dce2 to your computer and use it in GitHub Desktop.
Cross-platform VBA Function to get the OneDrive/SharePoint Url path/link from a local path of a locally synced folder
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ' Cross-platform VBA Function to get the OneDrive/SharePoint Url path (link) | |
| ' from a local path of a locally synced folder (Works on Windows and on macOS) | |
| ' | |
| ' The functionality previously provided in this gist is now available in the | |
| ' 'GetRemotePath function from the following gist: | |
| ' https://gist.github.com/guwidoe/038398b6be1b16c458365716a921814d | |
| ' Please use that instead! |
Hi @monitom and sorry for the late reply.
There seem to have been some OneDrive updates and I'll have to update this function accordingly.
Can you check if the GetRemotePath function from the current version of LibFileTools works on your machine?
Hi @monitom and sorry for the late reply. There seem to have been some OneDrive updates and I'll have to update this function accordingly. Can you check if the GetRemotePath function from the current version of LibFileTools works on your machine?
Hi @guwidoe - No worries at all. Thanks for your reply.
GetRemotePath in LibFileTools worked correctly for my purposes.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi @guwidoe,
I am encountering the same error as BlakeR94: "Run-Time error '457': The key is already associated with an element of this collection."
It's on line 5530 of my code...
5530 locToWebColl.Add VBA.Array(locRoot, webRoot & "/" & cid, email, _ syncID, syncFind, dirName), Key:=locRootNot entirely sure why this would error here?
Thanks!
Tom