4

I have an addin that I'm installing on the roaming profile of users.

Yet I have to activate it manually for every users.

enter image description here

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

  • 1
    Have you see the accepted answer here: experts-exchange.com/questions/28654905/…... 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 – Pimp Juice IT Jan 14 '17 at 23:29
  • Here's a post regarding the potentially needed GPP settings... blog.thesysadmins.co.uk/… 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 Jan 14 '17 at 23:30
  • Hi @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 Jan 15 '17 at 18:15
  • 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 Jan 15 '17 at 18:26
  • If 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 Jan 15 '17 at 18:34
1
+50

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.

  1. by regedit

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins

Configure a Registry Item with GPO

  1. technet article

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

  1. make changes in regedit.exe
  2. change content of text file in your installation directory
  3. copy dll to desired destination
  4. put your app in startup
  5. install background service in Windows
  6. show balloon tooltip for users like notifications in Android
  7. Run PowerShell commands for complete registration and activation
  8. copy every licence from Map Network drive to every target PC
  9. connect to your SharePoint Server or SQL Database and read information from excel shared filed

gpo install it in your joined computers and execute it (Members in your Active Directory)

| improve this answer | |
  • 1
    Hi @saber-tabatabaee-yazdi what do you mean by excel 2007 we can make mst file? Where you meaning MSI install file instead? – Andy K Jan 15 '17 at 18:00
  • i remember Microsoft office had tools for that that we make mst after msi browse – saber tabatabaee yazdi Jan 16 '17 at 7:29
  • 1
    hi @saber-tabatabaee-yazdi if you have any official doc, I'm all ears – Andy K Jan 16 '17 at 7:31
  • @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 Jan 16 '17 at 7:50
  • 1
    hi @saber-tabatabaee-yazdi, I found my solution – Andy K Jan 18 '17 at 16:06
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
| improve this answer | |
  • 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 May 7 '19 at 12:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.