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
 



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 09:35 PM.


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