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've an Excel and a Word Add-In and want to deploy them for a whole company. They are working with Windows Serer 2008 R2, Windows 7 and Office 2010. The network is managed with Active Directory.

The Add-In should be deployed and switched on on all Accounts / PCs automatically.

How can I do that? Are there any special things the Add-In has to full fill?

share|improve this question
    
How your network is organized? Do you use Active Directory for user accounts? –  Alexander Galkin Dec 16 '11 at 9:54
    
Yes we use Active Directory. –  BetaRide Dec 16 '11 at 10:04
    
SF question? <!-- filler --> –  Vi. Dec 16 '11 at 18:36

2 Answers 2

up vote 0 down vote accepted

If the Add-In installer is an MSI package then you can deploy it via GroupPolicy:

How to use Group Policy to remotely install software in Windows Server 2003 and in Windows Server 2008

share|improve this answer
    
No, it's a straight forward .xlam file. –  BetaRide Dec 16 '11 at 14:11
1  
Then you can pack it into an MSI: How do I deploy a VBA Excel Add-In (foo.xlam) using an msi installer? –  Robert Dec 16 '11 at 14:33

you can insert this code in your *.xlam in the sheet "ThisWorkBook" this code install and activate the current AddIns, just by opening

Private Sub Workbook_Open()
    Dim oXL As Object, oAddin As Object
    URL = Me.Path & "\"
    normalUrl = Application.UserLibraryPath ' Environ("AppData") & "\Microsoft\AddIns"
    AddinTitle = Mid(Me.Name, 1, Len(Me.Name) - 5)

    If URL <> normalUrl Then
        If MsgBox("Can you Install AddIns ?", vbYesNo) = vbYes Then
            Set oXL = Application ' CreateObject("Excel.Application")
            oXL.Workbooks.Add
            Me.SaveCopyAs normalUrl & Me.Name
            Set oAddin = oXL.AddIns.Add(normalUrl & Me.Name, True)
            oAddin.Installed = True

            oXL.Quit
            Set oXL = Nothing
        End If
    End If
End Sub
share|improve this answer

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.