How to: Re-enable a VSTO Add-in that has been disabled in excel

小菅秀紀 1 Reputation point
2022-08-17T10:42:04.853+00:00

I need to reable VSTO add-in by VBA.
Is there any means to do so?

I would like to cause same effect written below.

https://learn.microsoft.com/en-us/visualstudio/vsto/how-to-re-enable-a-vsto-add-in-that-has-been-disabled
To re-enable a VSTO Add-in
In the application, click the File tab.

Click the ApplicationName Options button.

In the categories pane, click Add-ins.

In the details pane, verify that the VSTO Add-in appears in the Inactive Application Add-ins list.

The Name column specifies the name of the assembly, and the Location column specifies the full path of the application manifest.

In the Manage box, click COM Add-ins, and then click Go.

In the COM Add-Ins dialog box, select the check box next to the disabled VSTO Add-in.

Click OK.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,450 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Oskar Shon 866 Reputation points MVP
    2022-11-08T17:13:25.86+00:00

    Addin comes from VS we name COM and you can write it using C# or VB.NET
    Addin build in VBA then XL file addin with VBA Code.
    You can not transfer one to another.
    If you like to use COM as Addin file you should rewrite it using VBA code (that id another lang do define and assigned objects).

    However you have list of file Addins in XL Application too, but you can not use it by default. Usually you can run a code file that is an add-on
    Solver that is a good example.

    https://vbatools-pl.translate.goog/dodatki-w-office-co-to-takiego/?_x_tr_sch=http&_x_tr_sl=pl&_x_tr_tl=en&_x_tr_hl=pl&_x_tr_pto=wapp

    0 comments No comments