Forum Discussion

Copper Contributor

May 14, 2020

Macro does not work on OneDrive. It only works in local folder

Good to all, I need help with a macro that at the time of executing a command when I have the files loaded in a folder in Onedrive it does not run, but when I have all in a folder locally it takes th...

excel

Formulas and Functions

Macros and VBA

office 365

KentKP

Copper Contributor

Mar 05, 2021

I am having a similar problem. Activeworkbook.Path shows https://mysp-cloud.kp.org/personal/.. .instead of C:\Users\<USERID>\OneDrive - <ORGNAME> ...

KentKP
Copper Contributor
Mar 05, 2021
SUPER MESSY SOLUTION: https://stackoverflow.com/questions/33734706/excels-fullname-property-with-onedrive

C'mon Microsoft!!!!!!!!