ID: Q140629
The information in this article applies to:
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.
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
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
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.
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.
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.
folder to which you installed Microsoft Excel.
4. Create a new module. In the module, click References on the Tools
menu. Click the Browse button.
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."
library file, for example Vbafr.olb. In the References dialog box,
click OK.
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.
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.
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)
ARTICLE-ID: Q119591
TITLE : How to Obtain Microsoft Support Files from Online Services
Keywords : kbprg xlwin
Version : 7.00
Platform : WINDOWSLast Reviewed: March 10, 1998