XL2002: The /Automation Command-Line Switch Does Not Disable COM Add-in Programs

Article translations Article translations
Article ID: 320058 - View products that this article applies to.
This article was previously published under Q320058
This article has been archived. It is offered "as is" and will no longer be updated.
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
Expand all | Collapse all

On This Page

Symptoms

When you use the /automation command-line switch to start Excel, COM add-in programs load unexpectedly. (The /automation switch should disable all automatically opened files and auto-run macros.)

Resolution

To resolve this problem, obtain the latest service pack for Microsoft Office XP. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
307841 OFFXP: How to Obtain the Latest Office XP Service Pack
The English version of this fix has the following file attributes or later:
   Date          Time   Size        File name
   -------------------------------------------------
   21-May-2002   10:13  13,297,756  Excel.msp
   21-May-2002   10:43  14,101,012  Excel_admin.msp
   21-May-2002   14:18       2,626  Readme.txt
				
After the hotfix is installed, the following files will have the listed attributes or later:
   Date          Time   Version         Size       File name
   ----------------------------------------------------------
   20-May-2002   23:27  10.0.4115.0     9,173,320  Excel.exe
   20-May-2002   23:27  10.0.4115.0     9,173,320  Excel.exe_1033
   20-May-2002   23:27  10.0.4115.0     9,173,320  EXcel.exe_1049
				

After you install this fix, use the steps in the "How to Enable Hotfix by using the QFE_Jasper Registry Key" section of this article to set the QFE_Jasper registry key and to turn on the fix.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft Office XP Service Pack 2 (SP-2).

More information

In Excel 2002, you can use the /automation switch to start Excel any of these ways:
  1. To load no COM add-ins or standard add-ins.
  2. To load only a specified add-in. To do this, list the ProgID of the COM add-in.
  3. To load multiple COM add-ins. To do this, list the ProgID for each one.
Example:

Excel.exe /automation Test.MyAddin MS.ComAddIn
The /automation switch can be combined with other existing command-line switches.

Example:

Excel.exe /automation COM Add-ins or XLAs, /a Automation Add-ins

How to Turn On the Hotfix by Using the QFE_Jasper Registry Key

To turn on the product fix listed in this article enter the following registry key and value. To do so:

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
  1. Quit Excel if Exel is running.
  2. Click Start, and then click Run.
  3. In the Open box, type regedit, and then click OK.
  4. Locate and then select the following registry key:
    HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options\
  5. Click the Edit menu, click New, and then click DWORD value.
  6. Type the following name for the new value:
    QFE_Jasper
  7. Press the Enter key.
  8. Right-click the QFE_Jasper registry key, and then click Modify.
  9. In the Value data box, type 1.
  10. Click OK, and then quit Registry Editor.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 320058 - Last Review: October 26, 2013 - Revision: 1.0
Applies to
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbnosurvey kbarchive kbhotfixserver kbqfe kbbug kbfix kbofficexppresp2fix kbofficexpsp2fix KB320058

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