How to Install Foreign Object Libraries on the Macintosh

Last reviewed: February 2, 1998
Article ID: Q118536
The information in this article applies to:
  • 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.

NOTE: In Microsoft Excel version 5.0 and 5.0a, you must create a new workbook, and then create the new module to use the new default Language/Country option.

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) 

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

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

For additional information, please see the following article in the Microsoft Knowledge Base:

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


Additional query words: 5.00 5.00a mac

Keywords : xlmac xlvbainfo kbfile
Version : MACINTOSH:5.00,5.00a
Platform : MACINTOSH
Issue type : kbinfo


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.