12-30-2020 06:55 AM
12-31-2020 05:20 AM - edited 12-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?
12-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.