We recommend using Visual Studio 2017

AddIn.RequestComAddInAutomationService Method

Returns an object in your add-in that can be used by other solutions.

Namespace:  Microsoft.Office.Tools
Assembly:  Microsoft.Office.Tools.Common.v9.0 (in Microsoft.Office.Tools.Common.v9.0.dll)

protected virtual Object RequestComAddInAutomationService()

Return Value

Type: System.Object
An object that you want to expose to other add-ins.

Override this method to expose an object in your add-in to other solutions. This includes other add-ins and document-level customizations running in the same application process, VBA code, and external automation code.

The object that you return must be public, it must be visible to COM, and it must expose the IDispatch interface. If the object you return does not meet these requirements, the Visual Studio Tools for Office runtime will throw an InvalidCastException after it calls your implementation.

For more information, see Calling Code in Application-Level Add-ins from Other Office Solutions.

For a code example that demonstrates how to override the RequestComAddInAutomationService method, see Walkthrough: Calling Code in an Application-Level Add-in from VBA.