Convert a OneDrive path to the local path

[FryGirl]

I use to be able to use application.path, but not with OneDrive. It seems to have thrown a wrench in that process. Below is what I get for where the file is on OneDrive, but the second line is the path copied from the folder on my hard drive. How can I convert the top line to the bottom line?

C:\Users\Brenda.Fry\OneDrive - military\Brenda_Fry_mil\Documents\Desktop\Files\Log\Measurement\
C:\Users\Brenda.Fry\OneDrive - military\Desktop\Files\Log\Measurement

This is the link that made line #1. Post #4 is what I used.

Get Local Path for OneDrive synced file [SOLVED]

I am simply shocked that I have not been able to find a simple solution to this. Excel and OneDrive are both Microsoft products so you would think they would work better together. I am looking for a simple way to get the path of the VBA file (activeworkbook) and use it to open another file...

www.excelforum.com

When I tested this at home it worked fine, but the way our office must configure OneDrive has introduced something different I don't know how to fix.

 

[Micron]

Not being a member of that forum, I can't see any posted code solutions so forgive me if I miss the mark here. You didn't say whether or not Sharepoint is involved at work or not. If it is, you probably need the UNC path of the SP server, which starts with \\. So like \\SharepointServerName\RootFolderName\TopFolderName1\...
If you have a drive letter mapped to the SP server, you can see its path by using Windows File Explorer.

 

[FryGirl]

Great Micron. Thank you for the help. I'll look into this more when I return to work on Monday, and yes, I do believe the SharePoint is involved.