Results 1 to 4 of 4
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Personal Macro Workbook: PERSONAL.XLS (2002)

    How does one transfer macros in an Excel 2002 PERSONAL.XLS running on a Windows 98 system, to Excel 2002 running on a Windows XP system?

    XP seems to handle PERSONAL.XLS in a different and inscrutable way.

    (I have a LOT of macros in my old PERSONAL.XLS, and I do NOT want to have to type them over on the new computer.)
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Personal Macro Workbook: PERSONAL.XLS (2002)

    Copy the Personal.xls file to

    Cocuments and Settings<username>Application DataMicrosoftExcelXLSTART

    on the Windows XP machine, where <username> is your Windows XP user name. Since it is already an Excel 2002 file, that should work without adaptation.

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Personal Macro Workbook: PERSONAL.XLS (2002)

    The safest way would be to open a new workbook on the XP system, record a macro, but in Record Macro dialog box, store macro in Personal Macro Workbook. Exit the macro and then exit excel. You don't need to save the workbook, but do save the changes in the Personal Macro Workbook. Then use an explorer search to find the new Personal.xls. Replace this workbook with a copy of your old Personal.xls. HTH --Sam

    PS Hans beat me to the punch, his way is absolutly correct also.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Re: Personal Macro Workbook: PERSONAL.XLS (2002)

    Found it! Thanks, guys.

    I'm just not accustomed to all this "Documents and Settings" and "username" stuff.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

Posting Permissions

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