Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 will not terminate with application.quit
When I use automation (VB, VBS, etc.) to open a workbook
in Excel 2003, the Quit method does not terminate the Excel process. Each time the script is executed, another Excel process is started, using about 10MB memory. I need to use Task Manager to kill the process, lest I run out of memory in a few days. Here is a sample script: Dim XLApp Dim XLWkb Set XLApp = CreateObject("Excel.Application") Set XLWkb = XLApp.Workbooks.Open("c:\xlbug.xls") XLWkb.Close Set XLWkb = Nothing XLApp.Quit Set XLApp = Nothing 'EXCEL.EXE should not be running anymore, but it is! You can open any workbook file. I tested with a small workbook file (two cells only) or a single-line text file - same result. This problems does not happen with Excel 2000. Thanks, Peter Schellenbach |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel application.quit in macro problem | New Users to Excel | |||
Excel application does not quit | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming | |||
Excel 2003 and Application.Quit | Excel Programming | |||
Macro to quit excel and go back to original application | Excel Programming |