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 Download Center. 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 files are available for download from the Microsoft Download Center. Click the file names below to download the files:

Frolb.exe

Grolb.exe

Itolb.exe

Brolb.exe

Spolb.exe

Svolb.exe

For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/search.asp

and then click How to use the Microsoft Download Center.

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:

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

From the Tools menu, choose References.

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:

Copy the object library files (VBA*.OLB) to the SYSTEM subdirectory of your Windows directory (C:\WINDOWS\SYSTEM, for example).

Copy the Microsoft Excel 5.0 object library files (XL*.OLB) to the directory to which you installed Microsoft Excel (C:\EXCEL, for example).

Start Microsoft Excel version 5.0.

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.

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

Choose the Browse button again. Select the SYSTEM subdirectory of the Windows directory.

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.

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.

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.00c

Keywords : kbinterop xlwin
Version : WINDOWS:5.0,5.0c
Platform : WINDOWS
Issue type :