![]() |
#1
|
|||
|
|||
![]()
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 | Thread Starter | Forum | Replies | Last Post |
Excel 2003 - Different Header for each page | franklyorange | Excel | 0 | 08-26-2008 02:26 PM |
Powerpoint 2003 - slides with Excel text | franklyorange | PowerPoint | 0 | 08-19-2008 09:30 AM |
![]() |
Richard Harison | Word | 3 | 12-20-2005 03:22 PM |
![]() |
Dave | Outlook | 2 | 12-15-2005 01:01 PM |
![]() |
markjean | Office | 1 | 12-06-2005 02:15 AM |