Results 1 to 8 of 8
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Object Library Not Found (XP)

    Hi Loungers,

    This morning I went to start Excel by double clicking a workbook and got the following msg box 3 times:
    "Object Library Not Registered"

    I could see in the status bar that it was complaining about the following:
    Funcres.xla
    Atpvbaen.xla
    Name Manager text.xla (yep Jan Karel's addin).


    Clicking on the Help button in the msg box brought up Help with some explanation but nothing that really helped (see below).

    This happened for spreadsheets created with XP, 2000, or just opening a blank workbook. Oc course, this did not happen as recently as a few days ago (when I was testing Jan Karel's Beta 3 of Name Manager <img src=/S/smile.gif border=0 alt=smile width=15 height=15>).

    When I went into the VBE to see about registering (not sure that I would know how to do this anyway), most of the menu choices are grayed out and there are no projects open in the Project Explorer. Not a surprise. I think the last time I looked, the above 3 items are the only ones that showed up (not counting the workbook).

    Any ideas on this?

    Thanks.

    Fred

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Object Library Not Found (XP)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Fred

    It seems to me that Excel was trying to open some of its "built-in" Add-Ins and it goofed.

    Did you try to open MS-Excel via the Start Button-Programs-...-MS-Excel?

    Try that and report back to us what happens.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

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

    Re: Object Library Not Found (XP)

    Might be sensible to do a Help, detect and repair from the main menu of Excel.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Object Library Not Found (XP)

    Wassim, Jan Karel:

    Thks for the suggestions. Nothing worked...yet. The plot thickens.

    As far as trying to open Excel via the Start Programs approach, that resulted in the same thing as in my original post.

    I know what add-in Excel is looking for when it complained about Name Manager <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.

    By the way, I think we need a smart smilie - one where you're tapping your forehead with your finger.

    I realized that Atpvbaen.xla is the Analysis Tool Pack for vba, which is another add-in I had checked.

    I assume {smart smilie goes here and where my grin smilie was} that Funcres.xla must have something to do with some of the Excel built-in functions because now RANDBETWEEN, which was working perfectly fine in my spreadsheet a few days ago on this PC, now shows a #NAME error. As does RAND and a few others I tried.

    So I tried Detect and Repair.

    I was a little concerned when the first dialog window mentioned something about you may have to insert your original CD. I bought this laptop at a show last spring and it had XP already installed but the seller didn't provide me with any program disks. But I chalked that up to the kind of support we've come to expect from resellers at shows.

    But I decided to go ahead anyway. It gets better.

    I then was concerned about the msg box that said it (Detect and Repair) was using Front Page Professional. OK, let it do its thing. But it finally did ask for the CD.

    Now even if I had the CD, which I don't, my external CD (Iomega CD burner) stopped working yesterday (it still is under warranty and they're shipping a new power cord as a first step). So couldn't put the CD in there even if I had it. The laptop came with an external bay where I can switch between a floppy drive and a (readable) CD. That's good but I don't have the CD.

    I clicked cancel. Did you ever see a progress bar go backward? I never have -- until now.

    That ended that.

    I tried unchecking the "guilty" add-ins but that doesn't do anything - Excel still complains.

    Now I closed Excel and tried Wassim's suggestion again. Now the link from the Start Programs menu seems corrupted and I get that Front Page repair window again (launched on its own). Of course, it asks for the CD and I don't have it.

    So I just launch Excel from the exe. Excel opens fine but the 3 add-ins aren't loaded since they were unchecked. I could probably live without at least 1, maybe even 2 of them for the present (I'm not saying which ones, Jan Karel).

    I try to add the add-ins back in. First, the Toolpack. I get the original error about object library.

    I try to add the Name Manager. Excel complains that it can't access the path x/y/z (the complete path for Name Manager) and gives 3 possible reasons. First is that the file does not exist at the path x/y/z. I check Win Explorer -- it's there, exactly where Excel said it was missing from. Second is that the file is being used by another program and I should close that program. Well, the only other programs I'm using right now are IE for writing this msg and Outlook Express and Word. Which one to close? I chose not to close IE. The third reason is that the name of the workbook that I'm trying to save is the same as another one that is read-only. Now this makes less sense in this case than the first 2 combined.

    So I'm stumped.

    I think I'll revert to my Office 2000. At least I have the CD for that. Now if I only had a working CD reader installed.

    Thanks guys. Any other suggestions welcomed.

    Fred

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

    Re: Object Library Not Found (XP)

    Doesn't your laptop have the install files somewhere on the HD? Maybe in a subfolder on another partition?
    Also, did the laptop come with a recovery CD (it would put it back in factory condition)?

    Sure sounds as if there is a problem with the Office install.

    Last resort: maybe he Excel registry entries got **ed up:

    Start, run,

    "crogram filesMicrosoft OfficeOfficeExcel.exe" /unregserver

    Followed by:
    Start, run,

    "crogram filesMicrosoft OfficeOfficeExcel.exe" /regserver

    (use the quotes, check the path)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Object Library Not Found (XP)

    Hi Jan Karel,

    OK, it's done.
    - the install files for Office XP are NOT on the disk and there's only 1 partition. I had checked that several times, including rechecking again today. I do have CAB files for windows 98 SE.
    - no recovery CD
    - did the last resort. Just needed to change the path ("Office10" instead of just "Office"). The unregistering worked fine. The re-register started out like the Detect and Repair, that is, with Front Page professional starting to run. So I didn't think it was going to work since I thought it would ask for the CD. It didn't and it finished and seemed to work fine. I went back into Excel. Added the Analysis Toolpack and the VBA Analysis Toolpack add-ins. Worked fine. Dare I add the Name Manager add-in?

    One unanswered question: how does one delete an entry from the add-in list? Not just uncheck the box but remove the line from the list so you don't even see it.

    Thanks.

    Fred

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

    Re: Object Library Not Found (XP)

    You can move the add-in file to another location. The next time you click the corresponding item in Tools | Add-Ins..., Excel will offer to remove the item since it can't be found.
    Alternatively, you can remove the item from the Windows Registry. Unchecked add-ins are listed in HKEY_CURRENT_USERSoftwareMicrosoftOffice10.0ExcelA dd-in Manager. Be careful when editing the registry.

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

    Re: Object Library Not Found (XP)

    <blockquote><hr>Dare I add the Name Manager add-in?<hr></blockquote>I guess you should be OK with that.

    Glad you got things up and running again.
    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
  •