SOLVED

Excel personal.xlsb to OneDrive

New Contributor

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?

1 Reply
best response confirmed by JoeFlesche (New Contributor)
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.