Accessing VSTO method in VBA

Question

I am trying to call the Shared Add-in COM Registerd method from VBA. I am using .NET Framework 2 and doing the code as it is in the post http://blogs.msdn.com/b/andreww/archive/2007/01/15/vsto-add-ins-comaddins-and-requestcomaddinautomationservice.aspx

But when i build the add-in i get the error

'RequestComAddInAutomationService()' no suitable method found to override

Please can anyone help me on this?

Answer 1

The error message suggests that none of the base classes of the class that contains your implementation of RequestComAddInAutomationService contains a definition of that method.

Make sure that your class actually derives from Microsoft.Office.Tools.AddIn.

Maybe it gets clearer if you follow this walkthrough:

Walkthrough: Calling Code in an Application-Level Add-in from VBA