SOLVED

Excel personal.xlsb to OneDrive

%3CLINGO-SUB%20id%3D%22lingo-sub-846816%22%20slang%3D%22en-US%22%3EExcel%20personal.xlsb%20to%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-846816%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20%3CSTRONG%3EOneDrive%20for%20Business%3C%2FSTRONG%3Eand%20I%20want%20to%20%3CEM%3Ebackup%3C%2FEM%3Emy%20Excel%20personal%20macro%20file%3B%20%3CSTRONG%3Epersonal.xlsb%3C%2FSTRONG%3E.%20I%20have%20tried%20many%20methods%20and%20did%20a%20fair%20amount%20of%20searching%20but%20cannot%20seem%20to%20figure%20this%20out.%20Any%20suggestions%20on%20how%20to%20automatically%20sync%20this%20file%20to%20OneDrive%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-846816%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853391%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20personal.xlsb%20to%20OneDrive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853391%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20appears%20that%20this%20is%20possible%20by%20using%20the%26nbsp%3B%3CU%3E%3CFONT%20face%3D%22courier%20new%2Ccourier%22%3E%3CSTRONG%3Emklink%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FU%3E%20statement.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3Emklink%20%2Fj%20%22C%3A%5CUsers%5C%7BUserName%7D%5COneDrive%5CBackup%5CXLSTART%5C%22%20%22C%3A%5CUsers%5C%7BUserName%7D%5CAppData%5CRoaming%5CMicrosoft%5CExcel%5CXLSTART%5C%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%20is%20that%20Excel%20puts%20a%20lock%20on%20%3CU%3E%3CSTRONG%3Epersonal.xlsb%3C%2FSTRONG%3E%3C%2FU%3E%20and%20will%20not%20sync%20it%20until%20Excel%20is%20closed.%20so%20far%20that%20is%20acceptable%20to%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted
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.