How to Install Foreign Object Libraries on the Macintosh

• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SUMMARY

Object library files are available for Microsoft Excel versions 5.0 and 5.0a for the Macintosh. 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.

FILES AVAILABLE FROM ONLINE SERVICES

   Item ID   File name      Description
   -----------------------------------------------------

   S20272    Frenolb.hqx    French object library files
   S20270    Deutsolb.hqx   German object library files
   S20273    Italolb.hqx    Italian object library files
   S20271    Espanolb.hqx   Spanish object library files

MORE INFORMATION

        -------------------------------------------
                          Microsoft(R) README for
                   Microsoft Excel Object Library Files
                               October 1996
        -------------------------------------------
                 (c) Copyright Microsoft Corporation, 1996
   ---------------------------------------------------------------------
   | INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY    |
   | ACCOMPANY THIS DOCUMENT (collectively referred to as a Microsoft   |
   | Software Library [MSL] file) IS PROVIDED "AS IS" WITHOUT WARRANTY  |
   | OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT        |
   | LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR        |
   | FITNESS FOR A PARTICULAR PURPOSE. The user assumes the entire risk |
   | as to the accuracy and the use of this MSL file. This MSL file     |
   | may be copied and distributed subject to the following conditions: |
   | 1) All text must be copied without modification and all pages must |
   | be included; 2) If software is included, all files must be copied  |
   | without modification; 3) All components of this MSL file must be   |
   | distributed together; and 4) This MSL file may not be distributed  |
   | for profit.                                                        |
   |                                                                    |
   | Copyright 1996 Microsoft Corporation. All Rights Reserved.         |
   | Microsoft is a registered trademark of Microsoft Corporation.      |
    --------------------------------------------------------------------

Visual Basic(R) for Applications and Microsoft Excel Object Library Files

If you create a Visual Basic for Applications macro in Microsoft Excel, in a language other than English, you should always include the appropriate language object library files when you distribute the Visual Basic application. If the macro calls procedures written in multiple languages, include the object libraries for each of the languages. In addition, 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.

Registering a Foreign Language Object Library

To register a foreign language version of an object library file, and reference it in a new Visual Basic project, do the following:

1. Copy the appropriate object library file to the following folder:

   <Macintosh HD>: System Folder: Extensions: Type Libraries

   where <Macintosh HD> is the name of your hard disk.

   The following table describes the naming convention for the foreign object library files that you must install, based on your computer platform.

          Object library name      Platform
          -------------------------------------------
   
          VBA ** OLB               68K Macintosh(R)
          VBA ** OLB (PowerMac)    Power Macintosh(R)
   
       NOTE: In the table above, the ** represents a two-letter abbreviation
       for the foreign language in which you are working.
   
          The following table lists the abbreviations (represented by ** in
          the table above) for the available foreign object libraries.
   
          Two-letter
          abbreviation       Language
          ---------------------------
   
          ES                 Spanish
          FR                 French
          DE                 German
          IT                 Italian
   
   

2. Copy the appropriate object library file to the folder in which you installed Microsoft Excel. The following table lists the foreign object library file names and their corresponding languages.

   Microsoft Excel

          foreign object library name      Language
          -----------------------------------------
   
          Biblioteca de Objetos de Excel   Spanish
          Lexique francais Excel           French
          Deutsche Excel-Objektbibli       German
          Libreria di oggetti di Excel     Italian
   
   

3. Start Microsoft Excel version 5.0 or 5.0a.

4. Insert a new Visual Basic module into a workbook. Activate the module, and click References on the Tools menu. Click Browse. Locate the folder in which you installed Microsoft Excel.

5. In the "List Files of Type" list, click Object Libraries.

6. In the list of files displayed in the dialog box, select the appropriate Microsoft Excel foreign object library file (see the table in Step 2), and click OK.

   A dialog box with the following message appears:

             Object library's language setting incompatible with
             current project.
   
   

7. Click OK.

8. In the References dialog box, click Browse again. Locate the folder that contains the foreign object library (see Step 1).

9. In the "List Files of Type" list, click Object Libraries.

10. In the list of files that appear in the dialog box, select the appropriate foreign object library file (see the table in Step 1), and click OK.

    A dialog box with the following message appears:

    Object library's language setting incompatible with current project.

11. Click OK.

12. Click OK to close the References dialog box.

    NOTE: If you want only to open a file that was created in a non-English version of Microsoft Excel, and the file contains a module sheet, you can click Cancel and skip steps 13 and 14. However, you can continue through step 13 to see whether the foreign object libraries are properly registered. To do this, click OK.

13. On the Tools menu, click Options. Click the Module General tab, and under International, select Default Settings. In the Language/Country list, select the language and country of the object library file you want to use, and click OK.

14. Create a Visual Basic module in a new workbook.

INSTRUCTIONS FOR DOWNLOADING

The following files are available for download from the Microsoft Software Library:

 ~ Frenolb.hqx (size: 202684 bytes) 
 ~ Deutsolb.hqx (size: 201955 bytes) 
 ~ Italolb.hqx (size: 199038 bytes) 
 ~ Espanolb.hqx (size: 201278 bytes) 

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

   ARTICLE-ID: Q141862
   TITLE     : How to Decode .hqx Files Downloaded from Online Services

REFERENCES

"Visual Basic User's Guide," version 5.0, Appendix A, "Writing Code For International Use".