Forum Discussion
Excel VBA to refer to files stored on OneDrive instead of local drive?
Hello, I have the following code that was originally written when I was storing my Excel files on my local machine. I moved all my files recently to OneDrive to take advantage of the automatic back...
Hello. If you have a minute, I was wondering how a network share url, for example, \\acme\home, would look and be accessed when moved to OneDrive. I know there is that local "C:\Users\<YourUsername>\OneDrive\<FolderPath>\" but wondering about how a share is handled. Thank you very much.
Migration from \acme\home to OneDrive
Scenario | VBA-Compatible Path | Notes |
Old Network Share | \\acme\home\folder | Accessible only if mapped or available on network |
OneDrive Synced Locally | C:\Users\<User>\OneDrive - <OrgName>\folder | Use this in VBA like a normal path |
OneDrive Web URL | https://onedrive.live.com/... | Not accessible in VBA without advanced APIs |
Unsynced OneDrive File | Not accessible from VBA | Sync it locally using OneDrive app |