ThisWorkbook.Path gives https:SPO path

We are migrating contents from NFS to Sharepoint Online. During the migration we realized that VBA code: ChDir ThisWorkbook.Path is using http://XXX.sharepoint.com. Even after syncing the file to local it point to this location. Kindly help

Since we have lots of such file it wont be possible to change it