Microsoft KB Archive/123442

{|
 * width="100%"|

XL5: Unexpected Results Using ExecuteExcel4Macro with CLOSE

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for Windows, version 7.0

-

SYMPTOMS
When you call an Excel 4 macro from a Visual Basic, Applications Edition, procedure using the Application.ExecuteExcel4Macro command, the strings "FILE.CLOSE" and "CLOSE" will not save changes unless you include the TRUE argument.

NOTE: This behavior is different from Microsoft Excel version 4.0. In Microsoft Excel 4.0, if you omit the argument, you are prompted to specify whether or not you want to save the changes.

WORKAROUND
If you want to be prompted to save changes when you close a file from a macro, use either of the following lines of code

 Workbooks(" ").Close where is the name of the file that you want to close  Application.ExecuteExcel4Macro "Close(True)" 

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.