3

I have small excel-like app in WPF. I would like to extend it with a possibility of embedding a VBA editor into it and exposing a small api to it. Pretty much the same way as the excel.

How to embed IronPython in a .NET application

Similar as this, but I would rather use VBA and not ironpython if possible.

Community
  • 1
  • 1
Mefhisto1
  • 2,188
  • 7
  • 34
  • 73
  • 1
    That's a very interesting question. It must be possible, because [Auto-cad did it](http://usa.autodesk.com/adsk/servlet/index?id=770215&siteID=123112), but I have no idea how. – RubberDuck May 06 '15 at 12:12
  • 3
    Project > Add Reference > COM tab > tick Microsoft Visual Basic for Application Extensibility. Getting pretty long on the tooth, finding docs for it beyond the Offfice usage isn't so easy. – Hans Passant May 06 '15 at 12:35
  • 1
    I'm not sure that really covers it @HansPassant. AFAIK, the extensibility library doesn't expose the actual runtime environment. Wouldn't it really require an reference to `VB6EXT.OLB`? – RubberDuck May 06 '15 at 13:51
  • Oh wait. That *is* the extensibility library.... – RubberDuck May 06 '15 at 13:55
  • 1
    This might help, but I'm finding dismally little information. https://msdn.microsoft.com/en-us/magazine/cc302278.aspx – RubberDuck May 06 '15 at 17:44
  • related https://stackoverflow.com/questions/30964634/using-vba-in-your-own-software – StayOnTarget Aug 09 '22 at 13:34

0 Answers0