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 95, 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("<filename>").Close

  where <filename> is the name of the file that you want to close

  -or-

• 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.

REFERENCES

For more information about ExecuteExcel4Macro,choose the Search button in Help and type:

   ExecuteExcel4Macro