Microsoft KB Archive/320058

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

Article ID: 320058

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q320058



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



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 &quot;How to Enable Hotfix by using the QFE_Jasper Registry Key&quot; 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, /a  

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.

 Quit Excel if Exel is running. Click Start, and then click Run. In the Open box, type regedit, and then click OK. Locate and then select the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options\

</li> Click the Edit menu, click New, and then click DWORD value.</li> Type the following name for the new value:

QFE_Jasper

</li> Press the Enter key.</li> Right-click the QFE_Jasper registry key, and then click Modify.</li> In the Value data box, type 1 .</li> Click OK, and then quit Registry Editor.</li></ol>

Additional query words: prb XL2002

Keywords: kbhotfixserver kbqfe kbbug kbfix kbofficexppresp2fix kbofficexpsp2fix KB320058

-

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

© Microsoft Corporation. All rights reserved.