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

• 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

   Document not saved

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.