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

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

SUMMARY

This article illustrates how to install an Excel Add-in (xla or xll) with Automation.
Back to the top | Give Feedback

MORE INFORMATION

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")
oXL.Workbooks.Add
Set oAddin = oXL.AddIns.Add("C:\test.xla", True)
oAddin.Installed = True
oXL.Quit
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
    -or-
    Run-time error '1004':
    Add method of addins class failed.
Back to the top | Give Feedback

REFERENCES

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
161439
(http://support.microsoft.com/kb/161439/ )
XL97: How to Remove Entries from Add-Ins Dialog Box
211956
(http://support.microsoft.com/kb/211956/EN-US/ )
XL2000: Cannot Delete Entries from Add-Ins Dialog Box
Back to the top | Give Feedback

Properties

Article ID: 280290 - Last Review: June 10, 2005 - Revision: 5.2
APPLIES TO
  • 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
Keywords: 
kbautomation kbhowto kbprogramming KB280290
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top