VBA and C# interop

Sign in to answer this question.

• 

  Vulpes14y agoPosted Sep 7, 2012, 1:52 PM

  Accepted answer

  Unfortunately COM is anything but simple but I've found something here which might help :
  
  http://blogs.artinsoft.net/Mrojas/archive/2010/06/23/Exposing-C-Classes-thru-Interop.aspx
• MM

  Mark Morrisson14y agoPosted Sep 7, 2012, 2:00 PM

  Thank you very much!
  Mark
  
• MM

  Mark Morrisson14y agoPosted Sep 7, 2012, 8:05 AM

  In fact, Visual Studio does all this stuff for you if you check the right options (registering the COM object and making them visible). As I said in my question, the problem is not to build a DLL that exposes a method, it's to build a DLL that exposes a method that returns a complex type. It does not work alone, so I'm looking for a simple tutorial/explanation to learn how to do it the simple way.
  
• 

  Vulpes14y agoPosted Sep 6, 2012, 3:45 PM

  The only realistic way for C# to interoperate with VBA is using COM, so I imagine you must have already created a COM-aware DLL and registered it with tlbexp.exe for anything to work at all. 
  
  As far as exposing your own classes are concerned they must be public and, to be on the safe side, they should be decorated with the attribute [ComVisible(true)].
  
  So I'd try that if you're not doing it already.