none
Can one make an Add-in for Outlook (2010 or later) with only VBA code? RRS feed

  • Question

  • Can one build an Add-in for Outlook (2010 or later), one that contains (or only contains) VBA macros. Or, do I need to get one of the higher-level languages?

    Thanks!

    Tuesday, February 11, 2014 7:44 PM

Answers

  • No, an Outlook add-in is a COM dll. VBA cannot produce executables, neither exes nor dlls.

    VB6 or VB.Net would work perfectly fine however.


    Dmitry Streblechenko (MVP)
    http://www.dimastr.com/redemption
    Redemption - what the Outlook
    Object Model should have been
    Version 5.5 is now available!



    Tuesday, February 11, 2014 7:56 PM
  • Hello,

    VBA is for macros only (not add-ins).

    Nowadays VSTO (Visual Studio Tools for Office) is used for building Office COM add-ins based on the .Net framework. The most widely used programming languages are VB.NET, C#, C++. I'd recommend reading the FAQ before asking something here.

    • Marked as answer by Marvin_Guo Wednesday, February 19, 2014 2:51 AM
    Tuesday, February 11, 2014 7:57 PM

All replies

  • No, an Outlook add-in is a COM dll. VBA cannot produce executables, neither exes nor dlls.

    VB6 or VB.Net would work perfectly fine however.


    Dmitry Streblechenko (MVP)
    http://www.dimastr.com/redemption
    Redemption - what the Outlook
    Object Model should have been
    Version 5.5 is now available!



    Tuesday, February 11, 2014 7:56 PM
  • Hello,

    VBA is for macros only (not add-ins).

    Nowadays VSTO (Visual Studio Tools for Office) is used for building Office COM add-ins based on the .Net framework. The most widely used programming languages are VB.NET, C#, C++. I'd recommend reading the FAQ before asking something here.

    • Marked as answer by Marvin_Guo Wednesday, February 19, 2014 2:51 AM
    Tuesday, February 11, 2014 7:57 PM