Nov 04 2019 02:44 AM
Hello,
Is it possible to automate opening an Office Add-in in Excel with PowerShell? I specifically mean one of the new add-ins available in Excel's own store (HTML/JS/CSS) and not one of the older VSTO add-ins.
Here's an example: say I want to open the Wikipedia Office Add-in (available in the Excel Add-in store), which opens a panel to the right. I have already added it to My Add-ins in the Insert ribbon menu, so there is no need to reinstall it.
In PowerShell I'd do something like this:
> $excel = New-Object -ComObject Excel.Application
> $excel.Visible = $True
> $workbook = $excel.Workbooks.Add()
At this point I've checked $excel.Addins, $excel.Addins2 and $excel.COMAddins, but I only find the old kind of add-ins there, not the new Office add-ins. Am I missing something? In this example I would simply like to open the Wikipedia add-in panel through PowerShell.