Load Office 2010 Excel Addins for All Users at Install Time?
I am using the Office Customization tool to setup a customized silent install of office 2010, and although it shows the Analysis Toolpak and Solver as configurable in the Set Feature Installation States section of the OCT, these options are greyed out, and the plugins are not active by default.
Is it possible to script out the activation of these plugins via commandline or registry?
UPDATE:
Figured out powershell script that does what I want.
$excel = New-Object -comobject excel.application
$excel.addins | foreach {$_.installed="true"}
$excel.quit()
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
jagadeish
12 years ago
Are you using updated OCT files?
Please walk through the following video
Comments:
-
updated OCT files? I don't know what you mean.
I did right click on the addins and select the option to install from computer. However, it does not make the addins active. I am trying to figure out how to activate them via script. - muebel 12 years ago -
You can download the latest version of the OCT and .opax settings files from the Microsoft Download Center
http://www.microsoft.com/en-us/download/details.aspx?id=18968
Have you tried editing Config.xml file to select those Excel Addins
http://technet.microsoft.com/en-us/library/cc179006 - jagadeish 12 years ago -
looks like using config xml will do it. will see how far I can get with that. - muebel 12 years ago