Start addins with startup excel

[wmbb]

I've created an excel addin and copied this file using a batch file to the users addin directory.
Now I want this addin to be installed automatically when excel is started because I don't want the users to make the developer toolbar visible and subsequently go to the addins and activate this addin.
Is there a way to activate (install) an addin by starting EXCEL ?

I've tried the code below but this doesn't work:

Private Sub Workbook_Open()
For i = 1 To AddIns.Count
    If AddIns(i).Name = "LIMStools.xlam" Then AddIns(i).Installed = True
Next i
End Sub

 

[combo]

Here's the way I a century ago distributed an add-in with an installer created with InnoSetup: thread707-595209.
If it's a frequent task I would use a master add-in (installed manually) and a list of managed add-ins. The list and add-ins could be updated witch a batch file, next the master add-in installs/uninstalls add-ins according to the list.


combo

 

[wmbb]

That is not exactly was I was looking for but the option to work with a second xls-file is an idea to try.
If I can put the code published in the xls-file and open this second file automatically in the batch file I think it will do what I want to do.
Thanks for pointing me in the right direction.

 

[wmbb]

How simple can it be.....
I've put the xlam-file in the startup directory (XLSTART) instead of the AddIns directory and there is no activation needed.
The macro's are available at Excel-startup. Exactly what I was looking for !