OneDrive/Sharepoint and VBA

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