XL5: Excel and Visual Basic Library Files (.OLB) Available

ID: Q122889

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c

SUMMARY

Object library files are available for Microsoft Excel and Microsoft Visual Basic for Applications. The files listed below are available to download from the Microsoft Software Library (MSL). For information on 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
   -----------------------------------------
   S15096    FROLB.EXE   French
   S15098    GROLB.EXE   German
   S15117    ITOLB.EXE   Italian
   S15099    BROLB.EXE   Portuguese (Brazil)
   S15097    SPOLB.EXE   Spanish
   S15118    SVOLB.EXE   Swedish

To Obtain these Files

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

 ~ FROLB.EXE (size: 136335 bytes) 
 ~ GROLB.EXE (size: 136504 bytes) 
 ~ ITOLB.EXE (size: 135273 bytes) 
 ~ BROLB.EXE (size: 135348 bytes) 
 ~ SPOLB.EXE (size: 136310 bytes) 
 ~ SVOLB.EXE (size: 132938 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

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 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 to 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       Visual Basic for
                for Windows           Applications
   Language     object library file   object library file
   ------------------------------------------------------

   French       XLFR50.OLB            VBAFR.OLB
   German       XLDE50.OLB            VBADE.OLB
   Italian      XLIT50.OLB            VBAIT.OLB
   Portuguese   XLPTB50.OLB           VBAPTB.OLB
      (Brazil)
   Spanish      XLES50.OLB            VBAES.OLB
   Swedish      XLSV50.OLB            VBASV.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. From the Tools menu, choose References.

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

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

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 subdirectory of

   your Windows directory (C:\WINDOWS\SYSTEM, for example).

2. Copy the Microsoft Excel 5.0 object library files (XL*.OLB) to the

   directory to which you installed Microsoft Excel (C:\EXCEL, for
   example).

3. Start Microsoft Excel version 5.0.

4. Create a new module. In the module, choose References from the Tools

   menu. Choose the Browse button. From the Directories list, select the
   directory where Microsoft Excel is installed.

5. From the File Name list, select the object library file (XLFR50.OLB, for

   example) and choose OK. Choose OK in the dialog box that appears with
   the error message "Object library language setting incompatible with
   current project."

6. Choose the Browse button again. Select the SYSTEM subdirectory of the

   Windows directory.

7. From the File Name list, select the object library file, for example

   VBAFR.OLB, and choose OK. Choose OK in the dialog box that appears
   with the error message "Object library language setting incompatible
   with current project." Click OK to close the References dialog box.

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

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

For more information, see Appendix A, "Writing Code For International Use," in the Visual Basic "User's Guide" that comes with Microsoft Excel 5.0.

Additional query words: 5.00 5.00c

Keywords          : kbinterop xlwin 
Version           : 5.00 5.00c
Platform          : WINDOWS

Last Reviewed: September 3, 1997