Q117135

• Microsoft Visual Basic for Applications version 1.0
• Microsoft Excel for Windows, version 5.0
• Microsoft Project for Windows, version 4.0

SYMPTOMS

When you move or copy a Microsoft Visual Basic Programming System, Applications Edition module from one project (such as a Microsoft Excel workbook or a Microsoft Project project), into another project, the code in the module is translated to the language used in the receiving project. If the receiving project does not already contain a module, the inserted module is translated to the language of the default Language/Country setting in the Module General tab of the Options dialog box.

CAUSE

All modules contained in a project must use the Language/Country setting that is designated for that project. Therefore, when you insert a module into another project, the code contained in the module is translated to the language that is used in the project into which the module is inserted. This is true even when the project into which you insert the module does not yet contain a module. In this case, the project uses the default Language/Country setting, and the code contained in the module that you insert into this project is translated to this language.

The referenced languages must correspond to the Language/Country setting for the project. You can, however, reference a project using one language from a project written in another language.

Note that objects and text strings are not translated when you copy or move a module into another project.

WORKAROUND

To work around this behavior, use either of the following methods:

• Move or copy the module back to the original project to translate the code in the module back to the original language.


-or-


• Change the default Language/Country setting to the language that is used in your module, create a new project using this default, and then move or copy the module to the new project.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

For more information about referencing a foreign language object library in an application that supports Microsoft Visual Basic Programming System, Applications Edition, query on the following in the Microsoft Knowledge Base:

visual and basic and foreign and library and error

Additional query words: intl

Keywords :
Issue type :
Technology : kbExcelSearch kbZNotKeyword6 kbExcel500 kbProjectSearch kbVBASearch kbZNotKeyword3 kbProject400 kbVBA100