4
3
I have an addin that I'm installing on the roaming profile of users.
Yet I have to activate it manually for every users.
I thought about activating it automatically with GPO.
I read that but it seems to be big for what it is.
Is there a way to activate it automatically with a GPO, in a simpler way?
Thanks
Andy K
Posted 2017-01-11T11:53:26.780
Reputation: 355
1
I found a way to make my addin, enabled through a GPIO
You copy the addin on the user's machine and enabled it with the following command line in a command prompt
reg add HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options /v OPEN /t REG_SZ /d "DW_connector.xlam"
Please note that you will need to put to change the version of office, based on your version of excel
- Excel 2016 - HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options
- Excel 2013 - HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Options
- Excel 2010 - HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
- Excel 2007 - HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options
Andy K
Posted 2017-01-11T11:53:26.780
Reputation: 355
That's fine if this is the first add-in installed on each account. But if one is already installed, then the registry entry OPEN is already taken, and you must use OPEN1. Then OPEN2, OPEN3, etc. – Jon Peltier – 2019-05-07T12:36:32.627
1
first solution that need to test:
i remember that in excel 2007 we can make mst file and install with msi in your network by active directory GPO
In this walkthrough we will create a custom Office 2007 source. We will customize our Office 2007 installation via the config.xml and the Office Customization wizard.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins
Configure a Registry Item with GPO
Another solution If you can programming or have a programmer in your team, Create New project with Visual Studio and generate msi file that do those actions you need.
then use Group Policy to remotely install software with OU's
you can do more actions with DotNet by C# or VB.net or other syntaxes.
actions like copy activate file to specific directory or etc. here is examples
gpo install it in your joined computers and execute it (Members in your Active Directory)
saber tabatabaee yazdi
Posted 2017-01-11T11:53:26.780
Reputation: 1 323
1Hi @saber-tabatabaee-yazdi what do you mean by excel 2007 we can make mst file? Where you meaning MSI install file instead? – Andy K – 2017-01-15T18:00:19.400
i remember Microsoft office had tools for that that we make mst after msi browse – saber tabatabaee yazdi – 2017-01-16T07:29:41.753
1hi @saber-tabatabaee-yazdi if you have any official doc, I'm all ears – Andy K – 2017-01-16T07:31:21.757
@AndyK updated the answer .... line 4 ... click on link walkthrough .. if problem comment for me ... This question has an open bounty worth +50 reputation from Andy K ending in 4 days. – saber tabatabaee yazdi – 2017-01-16T07:50:51.340
I tried by regedit. I could not find the regkeys as mentioned in your example. I tried to create them both in current user and local machine. Then I deactivated the addin, closed excel and hoping that excel would reactivate it. But no luck, the addin is still deactivated – Andy K – 2017-01-16T09:50:41.283
we cant suggest a crack or teach how to patchs softwares in superuser if you have licensed PC copy from there ...find it in windows registery ... your question about How to do that by GPO.. that possible – saber tabatabaee yazdi – 2017-01-18T13:59:42.183
1hi @saber-tabatabaee-yazdi, I found my solution – Andy K – 2017-01-18T16:06:57.967
1
Have you see the accepted answer here: https://www.experts-exchange.com/questions/28654905/Enable-an-Excel-add-in-that-has-already-been-installed-via-Group-Policy-GPO.html... `There are two reg keys that you'll need
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins
I would go to a machine that has it enabled and export the keys with the addin you want and run it in conjunction with GPO
I've provided the link as a guide to how to force enabling of addins
https://support.microsoft.com/en-us/kb/2733070%60
Here's a post regarding the potentially needed GPP settings... https://blog.thesysadmins.co.uk/group-policy-preferences-1-deploying-registry-settings.html to push the registry keys values to the needed machines via GPO... If you find this helpful and would like me to add as an answer, just hit me back and let me know... Good luck!!
– Pimp Juice IT – 2017-01-14T23:30:44.757Hi @ITSolutions, how do I save the reg keys and reimplement it on a different laptop? From far, your solutions seems to be the easiest but there are a few technicalities where I need some light... Thanks – Andy K – 2017-01-15T18:15:33.817
You essentially can just navigate to each of the regedit locations for both of those paths listed (on the machine where it works/is activated), and then select the actual reg folder with the name that correlates to the add-in, right-click on it and select export, and then save that to the desktop for example. Then the reg files that were exported can be copied over to the new machine that need to have this activated and then just double-click import those into the registry of the new machine. Now try, reboot and then try again, etc. Screen Shot Example
– Pimp Juice IT – 2017-01-15T18:26:26.037If you're asking how to implement this with GPP, I'd look here at this post and navigate down to Example 2 and implement that there with settings that match for the registry keys that export correlated to the add-in and use the UPDATE method as mentioned. I'll be glad to add as an answer with more detail if you find that this solves you're problem but this is the detail in brief and I know it's not super hard to complete (you're already familiar with GP).
– Pimp Juice IT – 2017-01-15T18:34:10.370Hi @ITSolutions I looked in regedit at the folder
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addinsand also forHKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins. I did not find anything in it... Any help are more than welcomed as it does not make sense where this ****ing addins is installing itself – Andy K – 2017-01-16T09:40:35.807@ITSolutions I tried by regedit. I could not find the regkeys as mentioned in your example. I tried to create them both in current user and local machine. Then I deactivated the addin, closed excel and hoping that excel would reactivate it. But no luck, the addin is still deactivated – Andy K – 2017-01-16T09:51:33.910
Start of my solution http://bettersolutions.com/excel/add-ins/registry-keys.htm
– Andy K – 2017-01-16T11:30:34.953and here too https://www.windows-commandline.com/add-registry-key-command-line/
– Andy K – 2017-01-16T11:30:50.280