XL7: MS Excel and Visual Basic Library Files (.olb) Available

Last reviewed: March 9, 1998
Article ID: Q140629
The information in this article applies to:
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a

SUMMARY

Object library files are available for Microsoft Excel and Microsoft Visual Basic for applications. The files are available to download from the Microsoft Software Library (MSL). For information about how to download these files, please see the "Instructions for Downloading" section later in this article.

FILES AVAILABLE FROM ONLINE SERVICES

   Item ID   File name      Description
   --------------------------------------------

   S15673    Danolb32.exe   Danish
   S15674    Dutolb32.exe   Dutch
   S15675    Finolb32.exe   Finnish
   S15676    Frolb32.exe    French
   S15677    Gerolb32.exe   German
   S15678    Itlolb32.exe   Italian
   S15679    Norolb32.exe   Norwegian
   S15680    Ptbolb32.exe   Portuguese (Brazil)
   S15681    Spnolb32.exe   Spanish
   S15682    Swdolb32.exe   Swedish

MORE INFORMATION

Visual Basic and Microsoft Excel Object Library Files

If your Visual Basic code in Microsoft Excel is written in a language other than English, you should always include the appropriate language object library files (.olb) when you distribute your Visual Basic application, in case the recipient doesn't already have the library files. If your code calls procedures written in multiple languages, then you should include the object libraries for each of those languages. You should also include all workbooks and other object libraries that are referenced by the application that you are distributing.

Microsoft allows all registered owners of Microsoft Excel to distribute object libraries with their applications to other registered owners as necessary. The names of the object library files available from Microsoft are listed in the following table.

                    Microsoft Excel for      Visual Basic for
   Language         Windows .olb file        Applications .olb file
   ----------------------------------------------------------------

   Danish           Xl5da32.olb              Vbada32.olb
   Dutch            Xl5nl32.olb              Vbanl32.olb
   Finnish          Xl5fi32.olb              Vbafi32.olb
   French           Xl5fr32.olb              Vbafr32.olb
   German           Xl5de32.olb              Vbade32.olb
   Italian          Xl5it32.olb              Vbait32.olb
   Norwegian        Xl5no32.olb              Vbano32.olb
   Portuguese       Xl5ptb32.olb             Vbaptb32.olb
      (Brazil)
   Spanish          Xl5es32.olb              Vbaes32.olb
   Swedish          Xl5sv32.olb              Vbasv32.olb

Determining the Location of an Object Library

To determine the location of an object library on your computer's hard disk, do the following:

  1. In Microsoft Excel, switch to a Visual Basic module sheet in a workbook.

  2. On the Tools menu, click References.

  3. From the Available References list, select the library name.

The library file location is listed next to Path under Description.

This procedure is also useful for determining which object library files you should distribute with your application. The check box next to a referenced object library file is selected.

Registering a Different Language Version

To register a different language version of an object library file and to reference this language version in a new Visual Basic project, do the following:

  1. Copy the object library files (VBA*.olb) to the System subfolder of your Windows folder, for example in c:\Windows\System.

  2. Copy the Microsoft Excel 7.0 object library files (Xl*.olb) to the folder to which you installed Microsoft Excel.

  3. Start Microsoft Excel version 7.0.

  4. Create a new module. In the module, click References on the Tools menu. Click the Browse button.

  5. Locate and select the Microsoft Excel object library file, for example Xl5fr32.olb, and click OK. Click OK in the dialog box that appears with the error message "Object library language setting incompatible with current project."

  6. Repeat step 5 with the Visual Basic for applications object library file, for example Vbafr.olb. In the References dialog box, click OK.

  7. Click Options on the Tools menu. 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. Click OK.

  8. 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.

INSTRUCTIONS FOR DOWNLOADING

The following file(s) are available for download from the Microsoft Software Library:

 ~ Danolb32.exe (size: 124456 bytes) 
 ~ Dutolb32.exe (size: 125945 bytes) 
 ~ Finolb32.exe (size: 126743 bytes) 
 ~ Frolb32.exe (size: 126975 bytes) 
 ~ Gerolb32.exe (size: 126213 bytes) 
 ~ Itlolb32.exe (size: 125814 bytes) 
 ~ Norolb32.exe (size: 124922 bytes) 
 ~ Ptbolb32.exe (size: 125563 bytes) 
 ~ Spnolb32.exe (size: 126209 bytes) 
 ~ Swdolb32.exe (size: 124063 bytes) 

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services


Additional query words: 7.00 foreign
Keywords : kbprg xlwin kbfile
Version : 7.00
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 9, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.