note 37325 deleted from ref.com by danbrown
| From: | danbrown@php.net | Date: | Mon, 21 Dec 2009 17:13:40 +0000 |
| Subject: | note 37325 deleted from ref.com by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-164224@lists.php.net to get a copy of this message | ||
Note Submitter:
----
RE: PROBLEM QUITTING MICROSOFT EXCEL
I strongly suspect this is due to excel helpfully asking "Do you want to save the changes you
made to 'Book1'?" when Quit is called.
This can be avoided by making sure that you set the 'Saved' property to True on ALL
workbooks before exiting.
Assuming you only have the one workbook:
$excel->ActiveWorkbook->Saved = 1
Word suffers a similar problem and you must set the saved property to true on each document.
This demonstrates the pitfalls of scripting Word, Excel and similar applications in a
non-interactive environment.