Recently I had the need to automate the process of installing Excel Add-ins in a terminalserver (or more correctly Remote Desktop Services environment since this was Windows Server 2008 R2) environment.
Since Excel Add-ins are per-user based, this was in the first place a manual setting. Of course we wanted to automate this process, so I researched a bit on the internet and found mostly VBScripts. I
ve used this KB-article as a template.
Although this worked very well, Im trying to leverage the use of PowerShell as much as possible. Many would say that VBScripts load much faster, and are more effecient as logonscripts.
Even though PowerShell v1 was a bit slow due to the lack of assemblies not being ngen
ed, as described on the PowerShell Teams Blog, this bug is fixed in v2 and I`m quite happy with the loading time now.
I used an if-statement to check if the Add-in are already installed, to avoid installing it on every logon.
When tested and ready for production, the script may be distributed as a traditional logonscript, or alternatively with Group Policy: