Solved

Object Library Not Registered - Excel 5

Posted on 1997-12-22
5
1,560 Views
Last Modified: 2012-06-21
In Excel 5, when trying to create a macro or open a file that has a macro in it, I get an "Object Library Not Registered" message.  It appears that the .olb files are loading okay though, since the proper language appears in the Tools, Options, Module General tab.  If I try to install the Visual Basic Add-in, I get the object library error and then it also states that it can't access the file c:\msoffice\excel\library\analysis\atpvbaen.xla, although that file is in that directory.  Any ideas?
0
Comment
Question by:ldobias
  • 3
  • 2
5 Comments
 
LVL 25

Expert Comment

by:dew_associates
ID: 1606489
LDobias: I presume that your using a Power Mac computer. If that's not the case, merely use the Non-Power Mac anser. If neither work, let me know and we will look into more serious problems.

These problems occur because the non-Power Macintosh version of Microsoft Excel is not specifically designed to run on a Power Macintosh.
 
To resolve these problems, use any of the following workarounds.
 
Method 1: Install Microsoft Excel for the Power Macintosh (rather than Microsoft Excel for the Macintosh).
 
Method 2: If you don't want to install Microsoft Excel for the Power Macintosh, use the following steps to correct the problem:
 
1. Create an alias for the Microsoft Excel application and copy it to the  Microsoft Excel folder on the hard disk. If you are using Microsoft Office for the Power Macintosh copy the alias  to the Microsoft Office:Microsoft Excel 5 folder.
 
2. If server based, then copy the entire Type Libraries folder from the Microsoft Office:__SetupAdmin__ folder on the server to the local System Folder:Extensions folder.
 
3. Start Microsoft Excel by double-clicking the alias that  was just created. This registers Microsoft Excel.
 
NOTE: If Microsoft Excel has already been run from the server, not all of the problems will be resolved. If that is the case, then do the following:
 
a. Move the Registration Database and PPC Registration
    Database files from the System Folder:Preferences folder to
    the desktop.
 
b. Run Setup from the Setup icon in the Microsoft Office folder
    on  your hard disk.
 
c. Choose Reinstall.
 
Once this procedure is successful, you can drag the Registration Database and PPC Registration Database files from the desktop to the trash.
 
To update Microsoft Office Manager:
 
1. Click customize on the Office Manager menu.
 
2. Click the check box next to Microsoft Excel and then close the Office Manager window.

======================
Non-Power Mac
======================
1. Copy the object library files (VBA*.OLB) to the SYSTEM subdirectory of your Windows directory (for example, C:\WINDOWS\SYSTEM). Copy the Microsoft Excel 5.0 object library files (XL*.OLB) to the directory in which you installed Microsoft Excel (wherever EXCEL.EXE is located).
 
2. Start the application that you are using to create the Visual Basic module, for example, Microsoft Excel version 5.0.
 
3. Create a new module. In the module, choose References from the Tools menu. Choose the Browse button. From the Directories list, select the Windows SYSTEM subdirectory.
 
4. From the File Name list, select the object library file (for example,  XLFR50.OLB) and choose OK. Choose OK in the dialog box that appears with the error message above.
 
5. Repeat step 4 with the Visual Basic for Applications object library file (for example, VBAFR.OLB). In the References dialog box, choose OK.  

6. From the Tools menu, choose Options. Select the Module General tab, and under International, select Default Settings. From the Language/Country list, select the language and country of the object library file you want to use. Choose OK.
 
7. Create a Visual Basic module in a new project.
 
Note that in Microsoft Excel, you must create a new workbook and then create the new module to use the new default Language/Country option. In Microsoft Project, you must create a new project and then create the new macro, and the macro must be stored in the project file.

Post your results please.

Dennis
0
 

Author Comment

by:ldobias
ID: 1606490
I am actually using Excel 5.0 for Windows (in a Windows 3.1 environment).  I have checked to make sure all files are there that are necessary, and it appears that they are.  I have even re-installed the program and it doesn't seem to help.  The ATPVBAEN.XLA file is still not loading when it is accessed.  Any other ideas?
0
 
LVL 25

Expert Comment

by:dew_associates
ID: 1606491
LDobias: Is the file locked in any manner, password, user etc?
0
 

Author Comment

by:ldobias
ID: 1606492
The file does not appear to be locked in any way or have a password on it.  
0
 
LVL 25

Accepted Solution

by:
dew_associates earned 100 total points
ID: 1606493
Okay, here's some additional things to try:

Use either of the following methods:
 
Method 1: Open the Analysis ToolPak-Visual Basic for Applications add-in file before you run a procedure that contains an Analysis ToolPak Visual Basic for Applications function. In Microsoft Excel for Windows, open ATPVBAEN.XLA located in the LIBRARY\ANALYSIS subdirectory of the Microsoft Excel directory.

Method 2: Load the Analysis ToolPak-Visual Basic for Applications add-in before you run a procedure that contains an Analysis ToolPak - Visual Basic for Applications function by using these steps:
 
a. From the Tools menu, choose Add-Ins.
b. In the Available Add-Ins list, select the Analysis ToolPak-VBA check box, and choose OK.

Note that when you use Method 2, the Analysis ToolPak-Visual
Basic for Applications add-in file is loaded each time you run Microsoft Excel.
 
==========================
Here's some additional data for you!
-------------
This behavior has been reported to occur after installing the following
programs:
 
 - Action
 - Artisoft Co-session (In-sync)
 - Borland C++
 - cc:Mail
 - Compton's Encyclopedia (on compact disc)
 - CPAV (on network)
 - Crystal Ball (add-in for Microsoft Excel)
 - Design CAD 3D for Windows
 - Internet Anywhere (installs a System32 directory)
 - JD Edwards Fianancial
 - Lawson (on network)
 - Lotus 1-2-3 Release 5 for Windows
 - Lotus Approach version 3.0
 - Lotus Notes Reporter for Windows 1.0
 - Microsoft Visual C++
 - Netscape Navigator versions 1.1, 1.1B2, and 2.0
 - Network MCI Business
 - Novell network environment (workstation running local Windows and
   shared Microsoft Excel 5.0)
 - Open Database Connectivity (ODBC) Software Development Kit (from
   The Developer Network)
 - Microsoft Office for Windows, version 4.3c-CD
 - SAS
 - Visio 3.0
 - Watermark Enterprise Edition
 - WordPerfect
 - WIN32s operating extension
 - WRQ3000
 
The third-party products discussed here are manufactured by vendors
independent of Microsoft; we make no warranty, implied or otherwise,
regarding these products' performance or reliability.
 
WORKAROUND
==========
 
You may be able to work around this problem by decompressing or extracting
the original version of the Stdole.tlb file from the appropriate Microsoft
Excel 5.0, Office 4.2, or Office 4.3 disk to the Windows\System directory.
 
To decompress or extract the Stdole.tlb file, use the following
appropriate steps:
 
Microsoft Excel 5.0c
--------------------
 
Use the Extract utility, Extract.exe, to manually extract the file from
the Microsoft Excel .cab file that is located on the appropriate Microsoft
Excel Setup disk.
 
The Stdole.tlb file is located on the following disks in the following
.cab files.
 
Microsoft Office:
 
The .cab files that contain Stdole.tlb are listed in the following table.
 
   Version of Office    Disk format  Disk number     File
   -------------------------------------------------------------
 
   4.3                  DMF          23              Msoff23.cab
   4.3                  Non-DMF      32              Msoff32.cab
   4.2                  DMF          19              Msoff19.cab
   4.2                  Non-DMF      26              Msoff26.cab
 
Microsoft Excel:
 
The .cab files that contain Stdole.tlb are listed in the following table.
 
   Disk type     Disk number     File
   ----------------------------------------
 
   DMF           1               Excel1.cab
   3.5-inch      1               Excel1.cab
   5.25-inch     1               Excel1.cab
   720k          2               Excel2.cab
 
To extract the file from the disk, use the following steps:
 
1. Copy Extract.exe from Setup Disk 1 to the root directory on the local
   hard disk, or to a directory that is located in the PATH statement in
   the Autoexec.bat file.
 
2. Insert the Setup disk that contains the Stdole.tlb file in the
   floppy disk drive.
 
3. At the MS-DOS prompt, type the following:
 
      extract /y <drive>:\<directory>\<.cab file> /L c:\<windows>\system\
      stdole.tlb
 
   where <drive> is the drive that contains the Setup Disk, <.cab file> is
   the .cab file that contains the Stdole.tlb file that you want to
   extract, and <windows> is the Microsoft Windows directory on drive C.
 
   Note that you can use the /y switch to overwrite the existing
   compressed file without prompting. The space before the file name is
   required to properly extract the new file and overwrite the existing
   file.
 
Microsoft Excel 5.0
-------------------
 
If you are using Microsoft Excel 5.0, use the Decomp utility, Decomp.exe,
to manually decompress the file from the appropriate Microsoft Excel Setup
disk. Decomp.exe is available on the Microsoft Excel Setup Disk 1.
 
The disks that contain Stdole.tlb are listed in the following table.
 
   Disk type     Disk number
   -------------------------
 
   3.5-inch      7
   5.25-inch     9
   720k          9
 
To decompress the file, use the following steps:
 
1. Copy Decomp.exe to the root directory of the local hard drive, or to a
   directory that is located in the PATH statement in the Autoexec.bat
   file.
 
2. Insert the Microsoft Excel Setup disk that contains the Stdole.tlb file
   in the disk drive.
 
3. If you are using the stand-alone version of Microsoft Excel, type the
   following command at the MS-DOS prompt and press ENTER:
 
      decomp -f <drive>:\stdole.tl_ c:\windows\system\stdole.tlb
 
   where <drive> is the drive that contains the Microsoft Excel Setup disk
   that contains the (uncompressed) Stdole.tl_ file.
 
   You can use the -f switch to overwrite the existing uncompressed file
   without prompting.
 
   If you are using the version of Microsoft Excel that comes with
   Microsoft Office 4.3-CD, type the following command at the MS-DOS
   prompt and press ENTER:
 
      extract /y d:\setup.adm\disk32\msoff32.cab /L c:\windows\system
      stdole.tlb
 
If you are running Windows from a shared directory on a network, you may
need to copy the Stdole.tlb file to any or all of the following
directories:
 
   Windows\System (on the network)
   Windows (on the local computer)
   Windows\System (on the local computer; create it if it does not
   already exist)
 
In some cases, you may need to rename and extract Ole2conv.dll,
Ole2disp.dll, Ole2nls.dll, Compobj.dll, and Storage.dll to correct the
problem. You can find these files on the same disk that contains
Stdole.tlb. To extract the files, use the steps in this article.

0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now