Application.Quit

[Henry Hayden]

I have pretty well finished an Excel application- with the help of a few
contributors to this forum. I have, at the moment, one remaining
challenge: Application.Quit doesn't quit Excel entirely when you click
Excel's Close box. It just quits the application. It works in the code
of a button's CLICK() method, but not from the close box. I need to be
abpe to end Excel entirely. How can I do this?

Thanks in advance.


Henry
DPM MEllon




*** Sent via Developersdex http://www.developersdex.com ***

 

[Myles]

Henry,

Application.Quit should suffice as that command closes EXCEL (the
application).

 

[Bob Phillips]

Make sure that all object references are cleared down, and any active
workbooks are closed before quitting.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Henry Hayden]

THanks for the response. So fat I can't see anything that is still
open. If i click on the Close box, the workbook closes, but Excel is
still running. I have to click the Close box again to actually kill
Excel. I guess I'll have to do a little diffing before I find what the
snag is. This is a head-scratcher. Thanks, Bob.


Henry


*** Sent via Developersdex http://www.developersdex.com ***