Microsoft KB Archive/122889

{|
 * width="100%"|

-

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.

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

Keywords : kbinterop xlwin

Version : WINDOWS:5.0,5.0c

Platform : WINDOWS

Issue type :
 * }