Link to home
Start Free TrialLog in
Avatar of cjharr
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?
Avatar of Professor J
Professor J

first of all, please change the topic to Microsoft Excel Software.

my question is where were your macros located previously?
was your macros saved in the Personal.xlsb?
Avatar of cjharr

ASKER

yes, in personal.xlsb.
can you check if that file exists in the XLSTART Directory?
the directory is  C:\Users\yourusername\AppData\Roaming\Microsoft\Excel\XLSTART
ASKER CERTIFIED SOLUTION
Avatar of Professor J
Professor J

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cjharr

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\AppData\Roaming\Microsoft\Excel\XLSTART

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

Open in new window



replace the C:\Users\yourusername\AppData\Roaming\Microsoft\Excel\XLSTART  with the username you got from script and then enter then whole C:\Users\yourusername\AppData\Roaming\Microsoft\Excel\XLSTART  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.
Avatar of cjharr

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.