XL97: "Module Not Found" Error Opening Workbook

• Microsoft Excel 97 for Windows

SYMPTOMS

When you open a workbook in Microsoft Excel 97, you receive the following error message:

 Module not found

CAUSE

This problem occurs when all of the following conditions are true:

• In Microsoft Excel 5.0 or 7.0, you create a workbook that contains a Visual Basic module with a name that contains one or more exclamation points (for example, "Module!1") or question marks.

      -and-
  

• You open the workbook in Microsoft Excel 97, and then save it in the Microsoft Excel Workbook format.

      -and-
  

• You do not remove the exclamation points or question marks in the name of the module before you save the workbook.

      -and-
  

• You close, and then attempt to reopen the workbook.

Microsoft recommends that you remove exclamation points and other illegal characters from the module name when you first open the workbook in Microsoft Excel 97.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Excel 97 for Windows, Service Release 1.

MORE INFORMATION

For more information about problems you may encounter when module names include illegal characters, see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q158632
   TITLE     : XL97: Limitations for Naming Visual Basic Modules