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

• 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) 

   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.

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.

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.