Returns an object in your add-in that can be used by other solutions.
Protected Overridable Function RequestComAddInAutomationService As Object
Dim returnValue As Object returnValue = Me.RequestComAddInAutomationService()
protected virtual Object RequestComAddInAutomationService()
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.