Microsoft KB Archive/111906

From BetaArchive Wiki

XL5: GP Fault in VBA.DLL on Exit After Saving to Floppy Drive



The information in this article applies to:


  • Microsoft Excel for Windows, versions 5.0, 5.0c





SYMPTOMS

In Microsoft Excel, if you save a workbook that contains a Visual Basic module to a floppy disk, and then remove the floppy disk from the disk drive, if you then save the file with the same filename to another drive, you receive the following error message

File already exists

and then the following error message:

Document not saved

When you quit Microsoft Excel, you receive a general protection (GP) fault in module VBA.DLL.



CAUSE

In Microsoft Excel version 5.0, OLE objects, pivot tables, and Visual Basic modules require the use of data on the file that contains them. This means that when you use these objects in a workbook, the file that contains this workbook must be available when you choose the Save or Save As command on the File menu. In general, when you work with a file containing one of these objects on a floppy drive, you should keep the floppy disk in the drive while the file is open.

NOTE: This problem does not occur in Microsoft Excel for Windows NT version 5.0.



WORKAROUND

After you save a workbook that contains a Visual Basic module to a floppy drive, to avoid receiving these error messages, make sure the floppy disk that contains the workbook file is still in the drive before you save the file to another drive.

Additional query words: gpf

Keywords :
Version : WINDOWS:5.0,5.0c
Platform : WINDOWS
Issue type :
Technology :


Last Reviewed: October 6, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.