OneDrive/Sharepoint and VBA

Hi,
When OneDrive is active Thisworkbook.path or ActiveWorkbook.path cannot be used to manage files, as it shows a Sharepoint URL
I found some solution to parse the URL to find the local location of the file, but it will work on very few cases. For exemple if I move the OneDrive folder to an other drive (exemple D, I have to change the code, or if I have business and personnel OneDrive, or if I am syncing multiple tenant, or if users have a different configuration.

I know I can strop OneDrive, but is not really convenient.

Did some one find a solution to be able to retreive the real local file path, or is it a dead end ?

Thanks a lot for your help.

Regards,

TBF

Just replace the sharepoint url with the physical location of your OneDrive folder.

For example;

https://mycomapny-my.sharepoint.com/personal/username/Documents/filename.xlsm?web=1

Change to

C:\Users\username\OneDrive\Documents\filename.xlsm