Excel personal.xlsb to OneDrive

[JoeFlesche]

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?

[#2 · Accepted solution]

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.