XL: Can't Add References If Filenames Similar

ID: Q116189

The information in this article applies to:

Microsoft Excel for Windows, version 5.0
Microsoft Excel for Windows NT, version 5.0
Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel for Windows, you may be unable to add references to two different files when the names of the files are identical except for the presence of accent marks on certain characters in the filenames.

CAUSE

This problem occurs because the Visual Basic Programming System, Applications Edition, is sometimes "accent-insensitive." When filenames contain accented characters, such as "e" (acute accent), "e" (circumflex accent), or "i" (grave accent), the characters may be "remapped" to a non- accented character, such as plain "e" or "i."

WORKAROUND

To prevent this error from occurring, make sure your filenames differ by more than accents before you attempt to add references to them.

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 as it becomes available.

MORE INFORMATION

If you attempt to add a reference to a file named "RESUME.XLS" (where the "E" characters have acute accents) when a reference to a file named "RESUME.XLS" (standard English/American "E" characters) already exists, you may receive the following error message:

Name conflicts with existing module, project, or object library

This problem may occur whenever filenames include accented characters. For example, "e" (acute accent), "e" (grave accent), "e" (circumflex accent), and plain "e" are all considered to be the same character when you are adding references.

Additional query words:

Keywords : xlwin
Version : 5.00 7.00
Platform : WINDOWS
Issue type :