+ Reply to Thread
Results 1 to 4 of 4

How to copy 98-97 excel macros to excel 2000 (XP)

  1. #1
    will A
    Guest

    How to copy 98-97 excel macros to excel 2000 (XP)

    Pc was converted to Windows XP, and my excel macros are in 98-97 ver while
    the new version they installed was Excel 2000. Need to have my macros copied
    pls let me know is possible.

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon Will A

    No conversion is necessary. They should run just fine.

    HTH

    DominicB

  3. #3
    will A
    Guest

    Re: How to copy 98-97 excel macros to excel 2000 (XP)

    No its not running, I checked the Personal Macro file and nothing is there.
    However I still have a copy of the Personal.xls file from the old Windows ver
    98. Tried to copy it to XLstart directory but still wont work.

    "dominicb" wrote:

    >
    > Good afternoon Will A
    >
    > No conversion is necessary. They should run just fine.
    >
    > HTH
    >
    > DominicB
    >
    >
    > --
    > dominicb
    > ------------------------------------------------------------------------
    > dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
    > View this thread: http://www.excelforum.com/showthread...hreadid=483167
    >
    >


  4. #4
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Hi Will A

    The problem here isn't a problem with the code but a problem with the location of the code.

    If that's the case your best bet is probably to open the "old" personal workbook and export the macro (right click on the module in the VBE and select Export File). then open the "new" personal workbook and import the macro back in, and save the workbook.

    HTH

    DominicB

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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