VB.Net to VBA?

Is it possible to write code with .NET and have it work for VBA

Thanks



Answer this question

VB.Net to VBA?

  • ISV Buddy Team

    You'd still need the .NET framework installed, you cannot run .NET code without the framework.

    But yes you can, you'd make the .NET code avaliable via COM and then reference it from within VBA. There are articles on creating managed plug-ins for Office in the MSDN library, this would be the best place to start.

    There is also a .NET addin for developing managed code for Office. I think its called Office Tools for .NET, its quite expensive.

    But yeah you can do it.



  • VB.Net to VBA?