Microsoft KB Archive/899725

= An active Microsoft Excel process continues to run after you use a VBA macro to programmatically quit Excel =

Article ID: 899725

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003

-



SYMPTOMS
When you run a Microsoft Visual Basic for Applications (VBA) macro to programmatically exit Microsoft Excel, Excel appears to close as expected. However, an active Excel process continues to run.

This behavior may occur even when your VBA macro performs the following functions:
 * Closes all open workbooks
 * Calls the Quit method to exit Excel
 * Sets the Excel object to &quot;nothing&quot;



CAUSE
This behavior may occur if the following conditions are true:
 * A COM add-in is installed in Excel.
 * The COM add-in assigns an Excel or an Excel member reference to a global object.

For example, this behavior is known to occur when the Google Desktop search tool is installed in Excel. For more information about the Google Desktop search tool, visit the following Google Web site:

http://desktop.google.com



WORKAROUND
To work around this behavior, remove the COM add-in in Excel. To do this, follow these steps, as appropriate for the version of Excel that you are running.

Microsoft Office Excel 2007

 * 1) Click the Microsoft Office Button, and then click Excel Options.
 * 2) Click Add-Ins.
 * 3) Click Excel Add-ins in the Manage box, and then click Go.
 * 4) In the Add-Ins dialog box, click to clear the check box for the add-ins that are known to cause this behavior.
 * 5) Click OK.

Microsoft Office Excel 2003

 * 1) On the Tools menu, click Add-Ins.
 * 2) In the Add-Ins dialog box, click to clear the check box for the add-ins that are known to cause this behavior.
 * 3) Click OK.



MORE INFORMATION
Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Additional query words: excel2003 xl2003 xl2k3 excel2007 excel2k7 excel12 xl2007 xl2k7 xl12

Keywords: kbprogramming kbmacro kbaddin kbexpertisebeginner kbvba kbautomation kbtshoot kbprb KB899725

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.