I'm always stunned to see the level of VB6 expertise that remains in the world even two decades after Microsoft left it for dead.
Just look at the effort and knowhow that went into this VBA function that resolves the local file system path from the https url of workbooks synced to OneDrive/SharePoint:
Just look at the effort and knowhow that went into this VBA function that resolves the local file system path from the https url of workbooks synced to OneDrive/SharePoint:
https://gist.github.com/guwidoe/038398b6be1b16c458365716a921...