Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Tue, 19 Apr 2011 21:16:31 -0700, "Jim Cone"
wrote: Try closing all workbooks before calling quit. Something as simple as... Workbooks.Close Application.Quit If you are automating Excel, then you have to call quit on the object reference not "Application". Good tip - thank you. To make it work I ended up closing the workbooks one by one - something like: ActiveWorkbook.Close Savechanges:=False Workbooks("Name_01.xls").Close Savechanges:=False (Still working on this - the last workbook for some reason is not closing) As an aside, I always thought that "Application.Quit" will close all workbooks no questions asked. Again, Thank you. Andy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.Quit Does not Close the Application | Excel Programming | |||
difference application.quit & application.close | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming | |||
application.quit will not shut off application | Excel Programming | |||
Quit Application | Excel Programming |