After we install an Office Add-In on a PC, it doesn’t enable itself in excel by default as an active add-in. I’d like to do this via PowerShell if possible so thousands of users don’t have to manually do it. This is the closest thing I’ve found that would seem to work, but it doesn’t:
$xl=New-Object -ComObject excel.application
$xl.Application.COMAddIns | ?{$.Description -eq ‘Azure DevOps Add-in’} |%{$.Connect=$true}
$xl.Quit()
exit
Has anyone had any experience doing something like this. I’ve tried to manually change the start behavior in the registry and that doesn’t work at all.