XL97: Crash Saving Workbook If Module Name Contains Equal Sign
ID: Q159877
|
The information in this article applies to:
-
Microsoft Excel 97 for Windows
SYMPTOMS
When you save a workbook that contains one or more module sheets, you
receive an error and Microsoft Excel quits without saving the workbook.
If you are running Windows 95, you may receive the following error when you
attempt to save the workbook:
Excel caused an invalid page fault in module VBE.DLL at 0137:65037fb5
If you are running Windows NT 3.51 or later, you may receive the following
error when you attempt to save the workbook:
An application error has occurred and an application error log is being
generated.
excel.exe
Exception: access violation (0xc0000005), Address: 0x6504223d
CAUSE
This problem may occur if the workbook contains a module sheet with a name
that contains an equal sign (=).
In Microsoft Excel 97, module names can contain only alphabetic, numeric
and underscore characters; the equal sign character is not valid for module
names. However, earlier versions of Microsoft Excel allow module sheet
names to contain equal signs. Microsoft Excel 97 can successfully open
these files. However, when you attempt to save the workbook in the
Microsoft Excel 97 file format, you receive an error, and the workbook is
not saved.
WORKAROUND
To work around this problem, change the name of the module sheet to a valid
Microsoft Excel 97 module name before you save the file. To do this, use
the following steps:
- Open the workbook.
- Press ALT+F11 to activate the Visual Basic Editor.
- Click Project Explorer on the View menu to display the Project Explorer.
- In the Project Explorer, double-click the Modules folder for the
workbook.
- Select the module that has an equal sign in its name and press F4 to
display the Properties window for that module.
- In the Properties window, change the name of the module so that it
contains only valid characters (alphabetic, numeric and underscores are
valid).
- On the File menu, click "Close and Return to Microsoft Excel."
You should now be able to save the workbook without receiving the
error described in this article.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Additional query words:
XL97 8.0 gpf ipf
Keywords : xlloadsave xlvbmigrate
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug