Re: Excel not closing after using it via COM

On Wed, 24 Apr 2002 17:28:32 -0400, you wrote: >Thanks for the suggestion. I tried using SaveAs(...) in >addition to Save(), to no avail. Excel still stays resident. > >This is my "end" sequence, when i'm all done processing >the spreadsheet. Can anyone see any flaws or errors in >what i'm doing ?? > >$book->Save(); >$book->Close(); >unset($sheet); >unset($book); >$excel->Quit(); >com_release($excel); >unset($excel) > >I agree with a previous poster to this list; that it's >most likely an "undocumented" MS bug (are there any >other kinds of MS bugs? hehe) Since I can use .Quit() and Release from VB and from Visual Fox to get Excel out of memory, I kind of doubt that the problem is in Excel. It seems more likely that it has something to do with PHP's handling of com objects. Alan >--- >Scott Hurring >Systems Programmer >EAC Corporation >ScottH@eac.com >Voice: 201-462-2149 >Fax: 201-288-1515 > >> -----Original Message----- >> From: Helphand [mailto:helphand@pacbell.net] >> >> Not sure if this will help or not, but I had a similar >> issue using Perl. >> Turns out that it was popping up a dialog box on the server when >> I did a save or saveas and there was a pre-existing file with that >> same name. I solved it by first deleting the file, then doing a >> saveas and the problem went away. >> >> Scott >> >>