Forum Discussion
Thisworkbook.Fullname - determine local path with VBA
Hello, an Excel file saved in a OneDrive / Sharpoint folder returns the URL (https://xxxx-my.sharepoint ...) for Thisworkbook.fullname. There are various solutions on the net using the registry, En...
Resolve the problem of ThisWorkbook.Path returning a URL in OneDrive
If you want to get local path of ThisWorkbook in OneDrive and OneDrive for Buisness instead of URL, please refer to the following GitHub. It provides three deferent solutions:
https://github.com/Excel-VBA-Diary/GetThisWorkbookLocalPath