Solved

How do I transfer Excel 2010 macros to Excel 2013

Posted on 2014-10-07
9
474 Views
Last Modified: 2014-10-10
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?
0
Comment
Question by:cjharr
  • 6
  • 3
9 Comments
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40366727
first of all, please change the topic to Microsoft Excel Software.

my question is where were your macros located previously?
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40366738
was your macros saved in the Personal.xlsb?
0
 

Author Comment

by:cjharr
ID: 40366739
yes, in personal.xlsb.
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40366745
can you check if that file exists in the XLSTART Directory?
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40366747
the directory is  C:\Users\yourusername\AppData\Roaming\Microsoft\Excel\XLSTART
0
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40366754
if you are using other type of operating system, check here how to find the personal.xlsb folder

http://wheatblog.com/2011/08/where-is-the-excel-personal-macro-workbook-located/


once you found your personal.xlsb then open it, normally it should open as hidden window. you can unhide it, but it is preferred to be hidden. then all of your macros should work in 2013.

let me know if you have any issue.
0
 

Author Comment

by:cjharr
ID: 40366776
personal.xlsb is not present in the XLSTART directory
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40372914
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.
0
 

Author Comment

by:cjharr
ID: 40372981
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.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Driver Problem 12 83
Neat Receipts NM-1000 Portable Scanner 11 120
Free software for pdf to word conversion 4 44
audit logs in excel spreadsheet 1 46
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Viewers will learn how to use the Hootsuite Dashboard.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now