An active Microsoft Excel process continues to run after you use a VBA macro to programmatically quit Excel 2003 (899725)
The information in this article applies to:
- Microsoft Office Excel 2003
SYMPTOMSWhen you run a Microsoft Visual Basic for Applications (VBA) macro to programmatically quit Microsoft Office Excel 2003, Excel 2003 appears to quit as expected. However, an active Microsoft Excel process continues to run. This behavior may occur even when your VBA macro performs the following functions: - Your VBA macro closes all open workbooks.
- Your VBA macro calls the Quit method to quit Excel 2003.
- Your VBA macro sets the Excel object to "nothing."
CAUSEThis behavior may occur if the following conditions are true: - A COM add-in is installed in Excel 2003.
- 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 following add-in is installed in Excel 2003: - The Google Desktop search tool. For more information about the Google Desktop search tool, visit the following Google Web site:
WORKAROUNDTo work around this behavior, remove the COM add-in in Excel 2003. To do this, follow these steps: - On the Tools menu, click Add-Ins.
- In the Add-Ins dialog box, click to clear the Add-ins check box.
- Click OK to close the Add-Ins dialog box.
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.
| Modification Type: | Major | Last Reviewed: | 5/25/2005 |
|---|
| Keywords: | KbVBA kbmacro kbProgramming kbAutomation kbtshoot kbprb KB899725 kbAudEndUser kbAudDeveloper |
|---|
|