How to install an Excel Add-in (XLA or XLL) with Automation

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


This article illustrates how to install an Excel Add-in (xla or xll) with Automation.


The following code demonstrates how to use Automation to:
  • Add a new workbook.
  • Call the Add method of the AddIns collection to add the new add-in to the list of add-ins in Excel Add-In Manager.
  • Set the Install property of the AddIn object to True (equivalent to selecting the add-in the Add-in Manager).
    Dim oXL As Object, oAddin As Object
    Set oXL = CreateObject("Excel.Application")
    Set oAddin = oXL.AddIns.Add("C:\test.xla", True)
    oAddin.Installed = True
    Set oXL = Nothing
    Note that a workbook is added prior to calling the Add method in this example. The Add-in Manager in Excel is not available unless there is at least one visible workbook open. Without this line of code, you receive one of the following error messages:
    Run-time error '1004':
    Unable to get the Add property of the AddIns class
    Run-time error '1004':
    Add method of addins class failed.


For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
161439 XL97: How to Remove Entries from Add-Ins Dialog Box
211956 XL2000: Cannot Delete Entries from Add-Ins Dialog Box


Article ID: 280290 - Last Review: June 10, 2005 - Revision: 5.2
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Visual Basic 6.0 Professional Edition
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
kbautomation kbhowto kbprogramming KB280290

Give Feedback


Contact us for more help

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