Excel fails when Automation add-In loads

Article translations Article translations
Article ID: 284876 - View products that this article applies to.
This article was previously published under Q284876
Expand all | Collapse all

On This Page

SYMPTOMS

When Microsoft Excel loads an Automation add-in during cell edit mode, Excel fails. This problem only occurs with Automation add-ins that have been Demand Loaded into Excel.

CAUSE

This problem can occur when an add-in loads if the add-in displays a form or dialog box, or if the add-in makes an Automation request to Excel that tries to change the state of Excel. The following list includes samples of Automation requests that may cause Excel to fail when it is called while an Automation add-in loads during cell edit mode:
  • Programmatically change the current selection. For example:
    Application.ActiveSheet.Range("A1").Select
    					
  • Call a property or method of an item in the Windows collection. For example:
    Application.ActiveWindow.Zoom = 200
    					
  • Change an Excel setting such as the calculation mode. For example:
    Application.CalculationMode = xlManual
    					
All of these items are examples of code attempts to change the Excel environment, a workbook, or a worksheet; these types of actions are not permitted while in edit mode.

RESOLUTION

Do not try the above-mentioned actions while your add-in loads. Add-in methods that are called during the load include the Initialize method and, if your Automation add-in implements the IDTExtensibility2 interface, the OnConnection and OnStartupComplete methods as well.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Problem

  1. Start a new ActiveX DLL project in Visual Basic.
  2. From the Project menu, click Project1 Properties. Change the Project Name to TestAddIn, and then click OK.
  3. Add the following code to the code module for Class1:
    Private Sub Class_Initialize()
        MsgBox "Class_Initialize"
    End Sub
    					
  4. Build TestAddIn.dll.
  5. In Excel, start a new workbook.
  6. In Microsoft Office Excel 2003 or in Microsoft Excel 2002, follow these steps:
    1. On the Tools menu, point to Add-Ins, and then click Automation.
    2. In the list, click TestAddIn.Class1, and then click OK.
    3. In the Add-Ins dialog box, click OK.
    In Microsoft Office Excel 2007, follow these steps:
    1. Click the Microsoft Office Button, and then click Excel Options.
    2. Click the Add-Ins tab.
    3. In the Manage list, click Excel Add-ins, and then click Go.
    4. In the Add-Ins dialog box, click Automation.
    5. In the list, click TestAddin.Class1, and then click OK.
    6. Click OK.
  7. Type =a in any cell. A message box with the text "Class_Initialize" appears.
  8. Click OK to dismiss the message box. After a few seconds, Excel fails.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
291392 INFO: Excel COM Add-ins and Automation Add-ins

Properties

Article ID: 284876 - Last Review: February 9, 2007 - Revision: 4.2
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbautomation kbbug kbpending KB284876

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com