All sorted. I have simply hard coded the file path into the VBA code instead of using wbBook.Path, and it's now working fine with my OneDrive (SharePoint).

Thanks to anyone who looked!