cjharr
asked on
How do I transfer Excel 2010 macros to Excel 2013
Recently upgraded to Microsoft Excel 2013 and would like the macros I was using in Microsoft 2010 to be available. What steps do I need to make in order for this to happen?
was your macros saved in the Personal.xlsb?
ASKER
yes, in personal.xlsb.
can you check if that file exists in the XLSTART Directory?
the directory is C:\Users\yourusername\AppD ata\Roamin g\Microsof t\Excel\XL START
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
personal.xlsb is not present in the XLSTART directory
cjharr
i assume that your issue has been resolved. as you have accepted my previous comment.
if not, please let me know. per your last comment you mentioned that personal.xlsb is not present.
normally, with upgrade of 2010 to 2013, that file does not get deleted. unless it is deleted manually by user.
sometimes, the APP DATA folder is hidden, and sometimes the XLSTART is hidden. please make sure that you are checking for that file in the following folder. C:\Users\yourusername\AppD ata\Roamin g\Microsof t\Excel\XL START
please replace "yourusername" with the actual username of your machine. if you do not know your username for the computer then
put the below code into a notepad and save it as myvb.vbs and then save it in desktop and then open it it will show the machine logged username.
replace the C:\Users\yourusername\AppData\Roaming\Microsoft \Excel\XLS TART with the username you got from script and then enter then whole C:\Users\yourusername\AppD ata\Roamin g\Microsof t\Excel\XL START into the Run Bar in your start up and it will directly take you to that folder. if you see personal.xlsb there, open it and if you do not see it there. then that is it, it must have been deleted.
i assume that your issue has been resolved. as you have accepted my previous comment.
if not, please let me know. per your last comment you mentioned that personal.xlsb is not present.
normally, with upgrade of 2010 to 2013, that file does not get deleted. unless it is deleted manually by user.
sometimes, the APP DATA folder is hidden, and sometimes the XLSTART is hidden. please make sure that you are checking for that file in the following folder. C:\Users\yourusername\AppD
please replace "yourusername" with the actual username of your machine. if you do not know your username for the computer then
put the below code into a notepad and save it as myvb.vbs and then save it in desktop and then open it it will show the machine logged username.
Set wshShell = WScript.CreateObject( "WScript.Shell" )
strUserName = wshShell.ExpandEnvironmentStrings( "%USERNAME%" )
WScript.Echo "User Name: " & strUserName
replace the C:\Users\yourusername\AppData\Roaming\Microsoft
ASKER
Thanks, I did resolve the issue. The upgrade from 2010 to 2013 was also a part of migrating one laptop to another. Since the file was hidden it did not transfer. I apologize for the transparency of the laptop migration. Once I copied personal.xlsb from the old laptop to the new one everything worked just fine. I appreciate the direction.
my question is where were your macros located previously?