How to Deploy (.xla) Excel Add-In Via Group Policy

Posted by paris on Sep 15, 2009 in Fixes |
Excel Logo I had 4 XLA Files, that I need to roll out to multiple machines across a network. These XLA files needed to be installed in a certain order. I found some Visual Basic Scripting Code ( off AppDeploy.com ) to add the Add-In and Enable it ( Can do this manualy by going to Tools , Add ins ) On Error Resume Next Dim oXL Dim oAddin Set oXL = CreateObject("Excel.Application") oXL.Workbooks.Add Set oAddin = oXL.AddIns.Add("\\Network Path\NameOfXLAAddIn.xla", True) oAddin.Installed = True oXL.Quit Set oAddin = Nothing Set oXL = Nothing I saved this code in a .vbs file , and created a vbs file for each of the xla files that need installing. I then created a .bat file to run these in order. What I found was that only half of the XLA’s where being added to the machine. I checked in the local Add in’s directory ( C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\AddIns ) and the Addin’s wearn’t being copied from the server before being registered. I then added an xcopy function to the BAT file to copy the file manually before adding , and this resolved the issue xcopy "\\Server Path\Example.xla" "C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\AddIns" /y
VN:F [1.9.22_1171]
Rating: 8.7/10 (3 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)
How to Deploy (.xla) Excel Add-In Via Group Policy, 8.7 out of 10 based on 3 ratings

Tags: , , ,

3 Comments

geekChick
Mar 22, 2012 at 4:15 am

Brilliant! worked to add the solver add in for Office 2010 on Windows 7 machines!

VA:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
VA:F [1.9.22_1171]
Rating: 0 (from 0 votes)

 
Rob
Jul 25, 2013 at 2:37 pm

Would you happen to know how to use a GPO to enable the basic add-ins that come standard with Excel 2010? I have the Office 2010 ADMX files but don’t see a way to enable add-ins. I want all of my users to have the Solver add-in, etc. enable and don’t want to manually set them on each machine.

Thanks in advance for any help you can provide

VA:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
VA:F [1.9.22_1171]
Rating: 0 (from 0 votes)

 
paris
Jul 25, 2013 at 11:56 pm

The Solver Plugin looks like it’s called solver.xla , so find where it is on the machine and register it using the VBS code , or copy it from a network share and register!

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

 

Reply

Copyright © 2015 Welcome to Pariswells.com All rights reserved. Theme by Laptop Geek. Privacy Policy