XL5: Save As or Delete Dialog Box Doesn't Close on OK

ID: Q112178

The information in this article applies to:

SYMPTOMS

In the versions of Microsoft Excel listed above, when you use the SAVE.AS? function or the FILE.DELETE? function in a Microsoft Excel version 4.0 macro sheet, and you use ERROR(FALSE) to avoid displaying error messages, the Save As or the Delete dialog box does not close when you choose OK.

CAUSE

When you use ERROR(FALSE) in a macro, messages are not displayed. Additionally, the default button in both the "Replace existing... ?" message and the "Delete file ...?" message is automatically chosen. In Microsoft Excel version 5.0, the default button for the "Replace Existing...?" message and the "Delete File...?" message is NO. In Microsoft Excel version 4.0, the default button for these messages is YES.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

If you create a macro in version 4.0 that uses the SAVE.AS? function and you use ERROR(FALSE), if a file exists with the same name you type in the File Name box in the Save As dialog box, the file is overwritten because the default button in the "Replace Existing...?" message is YES. However, if you run the same macro in Microsoft Excel version 5.0, if a file exists with the same name you type in the File Name box in the Save As dialog box, the Save As dialog box does not close when you choose OK because the default button in the "Replace Existing...?" message is NO, which returns you to the Save As dialog box.

The same problem occurs when you use the FILE.DELETE?() function with ERROR(FALSE) because the default button for the "Delete File...?" message is NO and the file is not deleted.

Additional query words: 5.00 5.00c

Keywords          : kbprg PgmOthr 
Version           : WINDOWS:5.0,5.0c; MACINTOSH:5.0,5.0a
Platform          : MACINTOSH WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: December 2, 1997