+ Reply to Thread
Results 1 to 3 of 3

Transfer copy of macros in Personal.xlsb from one computer to another.

  1. #1
    Registered User
    Join Date
    04-12-2014
    Location
    Kemp, Texas
    MS-Off Ver
    Excel 2010
    Posts
    10

    Transfer copy of macros in Personal.xlsb from one computer to another.

    Is there an easy way to transfer the macros (in Personal.xlsb) in Excel on my old computer to a new computer with a new Excel?

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Transfer copy of macros in Personal.xlsb from one computer to another.

    Here's one approach...
    • Record a simple macro on the new PC...indicating that you want it in your PERSONAL.xlsb file.
    (Excel will create the file for you, when done recording)

    • Close Excel
    • Find the new file in the new PC

    • Copy the "old" PERSONAL.XLSB and paste it over the "new" PERSONAL.XLSB.

    • Open Excel

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Transfer copy of macros in Personal.xlsb from one computer to another.

    Yes, just make a copy of the file itself so it isn't lost. Place that file in service as is on your new computer.

    More info: https://support.office.com/en-nz/art...0-6e4c3f5ee566
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 01-15-2015, 05:53 AM
  2. [SOLVED] Copied personal.xlsb to another computer, macros won't execute
    By Rick K in forum Excel General
    Replies: 3
    Last Post: 10-27-2014, 10:19 AM
  3. How transfer macros from my PERSONAL.xls to another computer?
    By Carrfamily in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2013, 03:57 PM
  4. Exported Ribbon won't run macros from PERSONAL.XLSB
    By Sicrates in forum Excel General
    Replies: 1
    Last Post: 06-26-2012, 04:29 AM
  5. Macros in Personal.xlsb not available when Excel is opened from another app
    By Muskett32 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2012, 02:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1