Opening an Office Add-in in Excel with PowerShell

Copper Contributor

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.

0 Replies