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



The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft PowerPoint 2000
  • Microsoft Word 2000
  • Microsoft Outlook 2000

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.

Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbbug kberrmsg kbIntlDev KB220681