Dec 30 2020 06:55 AM
Dec 31 2020 05:20 AM - edited Dec 31 2020 05:21 AM
Thisworkbook.path gives wrong content
The Microsoft helpdesk advised me to just ask my question in this community in Dutch. But because that gives no response, I am now trying to ask the same question in Google English.
I'm using OneDrive, but I have turned off auto-save by default and I have the Files On-Demand option turned off.
Still, in macros, when I request the value of ThisWorkbook.Path, I get a https link with "//d.docs.live.net/xxxxxxxx" while the correct answer is "C: / OneDrive /".
How can I change this?
Dec 31 2020 08:03 AM
Afraid not, for files synced with OneDrive Excel returns the path on the latest. The path returned is the same as in File->Info.
To change behavior if only stop syncing OneDrive.