Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-04-2005, 05:25 PM
Peter Schellenbach
Guest
 
Posts: n/a
Default 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
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
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
Excel 2003 will not terminate with application.quit Run Outside application from toolbar button Richard Harison Word 3 12-20-2005 03:22 PM
Excel 2003 will not terminate with application.quit Application not found error when trying to open .pdf files. Dave Outlook 2 12-15-2005 01:01 PM
Excel 2003 will not terminate with application.quit access runtime application will not install markjean Office 1 12-06-2005 02:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft