none
How to install Excel Add-In for all users RRS feed

  • Question

  • I have an xll excel Addin. 
    My customers' IT people will install My Excel AddIn for every user in company and after install, they want the AddIn to be available to all users on a PC.  and they want silent installation.  Originally I thought I can add registry entry for each user. However, I find some users' entries are simply not shown up.  So this is not a solution. What else can I try? thanks

    Peace & Joy

    Thursday, March 3, 2016 11:28 PM

Answers

  • Hi Peace,

    >> I find some users' entries are simply not shown up

    What do you mean with this? Do you mean Options in the registry? For each excel addin there is an OPENn(where n is a number), and it depends on the current version of Excel.

    HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options

    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

    Without modifying the registry manually, I suggest you try the code below for every user to install an Excel add-in with automation.

    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

    # How to install an Excel Add-in (XLA or XLL) with Automation
    https://support.microsoft.com/en-us/kb/280290

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Monday, March 7, 2016 6:13 AM
  • There is a sample WiX installer that does per-machine installation of Excel-DNA add-in using the Windows ActiveSetup feature.

    See the blog post here: http://benoitpatra.com/2014/07/26/a-sample-wix-installer-using-the-activesetup-feature/

    and sample WiX project on Github: https://github.com/bpatra/ExcelDNAWixInstallerLM

    -Govert

    Excel-DNA - Free and easy .NET for Excel


    Monday, March 7, 2016 10:37 AM

All replies

  • Hi Peace,

    >> I find some users' entries are simply not shown up

    What do you mean with this? Do you mean Options in the registry? For each excel addin there is an OPENn(where n is a number), and it depends on the current version of Excel.

    HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options

    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

    Without modifying the registry manually, I suggest you try the code below for every user to install an Excel add-in with automation.

    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

    # How to install an Excel Add-in (XLA or XLL) with Automation
    https://support.microsoft.com/en-us/kb/280290

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Monday, March 7, 2016 6:13 AM
  • There is a sample WiX installer that does per-machine installation of Excel-DNA add-in using the Windows ActiveSetup feature.

    See the blog post here: http://benoitpatra.com/2014/07/26/a-sample-wix-installer-using-the-activesetup-feature/

    and sample WiX project on Github: https://github.com/bpatra/ExcelDNAWixInstallerLM

    -Govert

    Excel-DNA - Free and easy .NET for Excel


    Monday, March 7, 2016 10:37 AM