Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2001
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 97/XP object library problem (97 and XP)

    I have a sheet which was made in Excel 97, with lots of macros etc. When we try to open it in Excel XP/2002 we get the error message - 'object library not registered'.
    This is under a Win98/Office XP configuration. Don't ask me why it's been set up like this...

    Michael

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel 97/XP object library problem (97 and XP)

    Try the following

    When you goto to open the workbook hold down the shift key or disbale macros, so that it will not try to run any code. When you open the workbook goto the VB editor (Alt-F11) and click on Tools, References. You may see a reference marked MISSING, and it probably points to Microsoft Office 8.0 Object Libray (Office 97). Uncheck that and find a reference to Microsoft Office 10.0 Object Libray (Office XP), and make sure the check box is ticked.

    Andrew C

  3. #3
    New Lounger
    Join Date
    Sep 2001
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97/XP object library problem (97 and XP)

    Good idea, Andrew, but no luck. There's no missing reference, and no mention of Office 8 Object library...

    Michael

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97/XP object library problem (97 and XP)

    Could it be that this sheet has roots in Excel 5/95, using another Language version of VBA? (As from XL97 all VBA is US english, before that the language was local and one needed the local olb file, like VBAFR.OLB for a french version.

    If not, I guess something is wrong with the install of Excel. What you might try is locate the VBAEN.OLB file on your system, rename (or move or delete) it and start Excel. From the Help menu, choose detect and repair. Now Ofice install will probably prompt for the CD.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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