Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need to create something, bat scripts(?), to install an add-on for Excel 2003 so that the end user will not required to manually install add-on from Excel's manual Tool->Addin... then browse.

For example, my add-on is a file:

C:\Program Files\MyApp\bin\myAddin.xla

Any suggestions or just steps from command console to install the add-on?

The client PC is Windows XP based PC.

share|improve this question

1 Answer 1

Here is the wonderful step by step explanation available on this site or here.

But i would suggest that you can use automation is easy

From here

  • 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:

share|improve this answer
    
Nice link resources. Based on the information, I can copy the xla file to either folders (C:\Program Files\Microsoft Office\OfficeXX\Library or C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns). Then addin is in the Addin list. However, how can I make this item checked in the list? Somewhere in reg or xml config file? –  David.Chu.ca Oct 22 '09 at 15:53
    
Yes.................... –  joe Oct 22 '09 at 16:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.