Possible to create Personal.xlsb strictly with vba macro code?

[johnnyL]

For my next wishful thinking ... Is it possible to create this module in excel with just vba code? Everything I have read says that you have to start a macro recording for that folder and then stop the recording. This will autocreate the PERSONAL.XLSB module. Macro code to start and stop the recording, for that matter?

Any thoughts on a vba macro approach to do this?

If that seemingly impossible task is not doable, can a PERSONAL.XLSB file be copied from one computer to another? If so, would the versions of excel have to match? IE. could you copy an excel 2007 PERSONAL.XLSB file to a computer with excel 2016, for example? Would the operating systems involved matter?

Reason I am asking because I would like to set this up on the spouses computer at work. She doesn't know what version of excel she uses, much less if she has the PERSONAL.XLSB module already on there. I could go to her work and set this all up for her, but I was wondering if some macro code could do it for her, and me for that matter.

 

[alansidman]

I have copied personal.xlsb from one computer to another without issue. The two computers were using different versions of Excel.

 

[johnnyL]

Thank you @alansidman for that comment. Do you recall if the file you copied replaced the file on the other computer, or was it a 'new' file that hadn't previously existed.

 

[alansidman]

New File

 

[johnnyL]

Thank you for that info! That may then, be an avenue worth looking into.