Microsoft KB Archive/220681

= OFF2000: "Could Not Open Macro Storage" Error Message When Euro Character or Other Symbol Used in Module, Procedure or Macro Name =

Article ID: 220681

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft PowerPoint 2000 Standard Edition
 * Microsoft Word 2000 Standard Edition
 * Microsoft Outlook 2000 Standard Edition

-



This article was previously published under Q220681





SYMPTOMS
When you create a macro that contains the euro character (or any other European character) in the module, procedure, or macro name, you may receive the following error message:

Could not open macro storage.



CAUSE
The euro character is one of many special characters that you cannot use to name modules, procedures, or project items. Other European and Asian characters may also cause the problem. This error also occurs if you have used a space, period (.), exclamation mark (!), or the character @, &, $, #, or [] in the module name.



WORKAROUND
When you name your macro procedure, module, or macro, use standard alphanumeric characters from the English (U.S.) character set.



MORE INFORMATION
For more information about Visual Basic for Applications naming rules, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type Visual Basic naming rules in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: OFF2000 vba

Keywords: kbbug kberrmsg kbintldev KB220681

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.