Thisworkbook.path geeft verkeerde inhoud

%3CLINGO-SUB%20id%3D%22lingo-sub-2022661%22%20slang%3D%22en-US%22%3EThisworkbook.path%20geeft%20verkeerde%20inhoud%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2022661%22%20slang%3D%22en-US%22%3E%3CDIV%3EIk%20gebruik%20OneDrive%2C%20maar%20ik%20heb%20automatisch%20opslaan%20standaard%20uitgeschakeld%20en%20ik%20heb%20de%20Files%20On-Demand%20optie%20uitgeschakeld.%3C%2FDIV%3E%3CDIV%3EToch%20krijg%20ik%20in%20macro's%20als%20ik%20de%20waarde%20van%20ThisWorkbook.Path%20opvraag%20als%20resultaat%3A%20een%20https%26nbsp%3B%20link%20met%26nbsp%3B%20%22%2F%2Fd.docs.live.net%2Fxxxxxxxx%22terwijl%20het%20goede%20antwoord%20%22C%3A%2FOneDrive%2F%22%20is.%3C%2FDIV%3E%3CDIV%3EHoe%20kan%20ik%20dit%20veranderen%3F%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2022661%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2024383%22%20slang%3D%22en-US%22%3ERe%3A%20Thisworkbook.path%20geeft%20verkeerde%20inhoud%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2024383%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EThisworkbook.path%20gives%20wrong%20content%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThe%20Microsoft%20helpdesk%20advised%20me%20to%20just%20ask%20my%20question%20in%20this%20community%20in%20Dutch.%20But%20because%20that%20gives%20no%20response%2C%20I%20am%20now%20trying%20to%20ask%20the%20same%20question%20in%20Google%20English.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20OneDrive%2C%20but%20I%20have%20turned%20off%20auto-save%20by%20default%20and%20I%20have%20the%20Files%20On-Demand%20option%20turned%20off.%3CBR%20%2F%3EStill%2C%20in%20macros%2C%20when%20I%20request%20the%20value%20of%20ThisWorkbook.Path%2C%20I%20get%20a%20https%20link%20with%20%22%2F%2Fd.docs.live.net%2Fxxxxxxxx%22%20while%20the%20correct%20answer%20is%20%22C%3A%20%2F%20OneDrive%20%2F%22.%3CBR%20%2F%3EHow%20can%20I%20change%20this%3F%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EWhat%20do%20you%20want%20to%20do%20%3F%3C%2FDIV%3ENew%20mailCopy%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%3CIMG%20border%3D%220%22%20%2F%3E%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EWhat%20do%20you%20want%20to%20do%20%3F%3C%2FDIV%3ENew%20mailCopy%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%3CIMG%20border%3D%220%22%20%2F%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor
Ik gebruik OneDrive, maar ik heb automatisch opslaan standaard uitgeschakeld en ik heb de Files On-Demand optie uitgeschakeld.
Toch krijg ik in macro's als ik de waarde van ThisWorkbook.Path opvraag als resultaat: een https  link met  "//d.docs.live.net/xxxxxxxx"terwijl het goede antwoord "C:/OneDrive/" is.
Hoe kan ik dit veranderen?
2 Replies

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?

 
 

@AnneVddl 

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.