Forum Discussion
Excel personal.xlsb to OneDrive
I am using OneDrive for Business and I want to backup my Excel personal macro file; personal.xlsb. I have tried many methods and did a fair amount of searching but cannot seem to figure this out. Any suggestions on how to automatically sync this file to OneDrive?
It appears that this is possible by using the mklink statement.
mklink /j "C:\Users\{UserName}\OneDrive\Backup\XLSTART\" "C:\Users\{UserName}\AppData\Roaming\Microsoft\Excel\XLSTART\"Problem is that Excel puts a lock on personal.xlsb and will not sync it until Excel is closed. so far that is acceptable to me.
It appears that this is possible by using the mklink statement.
mklink /j "C:\Users\{UserName}\OneDrive\Backup\XLSTART\" "C:\Users\{UserName}\AppData\Roaming\Microsoft\Excel\XLSTART\"Problem is that Excel puts a lock on personal.xlsb and will not sync it until Excel is closed. so far that is acceptable to me.
