XL97: Crash Saving Workbook That Uses BeforeSave Event (177393)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q177393 SYMPTOMS
When you save a Microsoft Excel workbook in Microsoft Visual Basic
Editor, you may receive the following error message.
In Microsoft Windows 95
This program has performed an illegal operation and will be shut down.
If the problem persists, contact the program vendor.
If you click Details, you receive an error message similar to the
following:
EXCEL caused an invalid page fault in module KERNEL32.DLL at
0137:bff9a290.
In Microsoft Windows NT
Dr. Watson for Windows NT
An Application error has occurred and an application log is being
generated.
EXCEL.exe
Exception: Access violation (0xc0000005), Address: 0x301d09b5
NOTE: If another workbook is open, it is saved instead of the workbook
that you specified. You will receive no error message.
CAUSE
This problem may occur when using the BeforeSave event if either of the
following conditions is true:
- The IsAddin property of the workbook object returned by ThisWorkbook is
set to True.
-or-
- The workbook is hidden.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATIONREFERENCES
For more information about using the BeforeSave event, click the Office
Assistant in the Visual Basic Editor, type beforesave, click Search, and
then click to view BeforeSave Event.
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If the Assistant is not able to answer your query, please
see the following article in the Microsoft Knowledge Base:
176476 OFF: Office Assistant Not Answering Visual Basic Questions
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kbbug kberrmsg kbpending kbProgramming KB177393 |
|---|
|