none
What is the pros cons of VBA Add-ins, VSTO add ins web add-ins (Office add-ins) in excel RRS feed

  • Question

  • Hi Experts,

    May you all put light on  VBA Add-ins, VSTO add ins web add-ins in excel.

    I want to know which is better to use in a product keeping mind future Market.

    Hope every one will give their invaluable response.

    Regards,

    Divaker Pandey

     

    Monday, May 30, 2016 11:28 AM

Answers

  • I am not sure what you mean by "which feature of VBA/VSTO can be used through office add-ins and which are not".

    Once again, there are no VBA addins. VBA is what you get when you hit Ctrl+F11 - just a VB script that can use the Outlook Object Model. It is the same COM based object model used in straight IDTExtensibility2 or VSTO addins.

    Web addisn are JavaScript is the API is completely different. It is limited compared to the COM based API.


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

    Tuesday, May 31, 2016 2:10 PM
  • Hi Divaker Pandey,

    please visit the link below and select Excel from the sidebar menu.

    you will see all the objects with its description, syntax , examples are available there. with the help of that you can know which feature you can implement from which object. 

    JavaScript API for Office reference

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, June 3, 2016 5:25 AM
    Moderator

All replies

  • Deleted
    Monday, May 30, 2016 12:55 PM
  • There is no such thing as VBA Add-ins. You can have a VBA module (script) and you can have COM addins.

    VSTO addins are COM addins - they just make addin development easier.

    If you do not plan to distribute your code, VBA would work.

    If you need to distribute your code to other users, COM addins (straight IDTExtensibility2 or VSTO) are the way to go.

    Web addins run on all platforms, but the API currently  is extremely limited.


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

    Monday, May 30, 2016 9:32 PM
  • Hi Divaker Pandey,

    VSTO (Visual Studio Tools for Office) Addin is a great means of customizing Office applications, especially the UI. VSTO allows us to customize task panes which is impossible with VBA (Visual Basic for Applications). It is much easier to customize ribbons in VSTO using ribbon designer, which makes creating new groups and adding controls to the ribbon as intuitive as adding control to a windows form, compared to VBA which uses Ribbon. Even then it is still the primary choice for many developers because of the Macro recording feature which helps the developers to record a certain repetitive task and then modify to suit their requirements using Visual Basic Editor.

    VSTO is a part of the Microsoft Visual Studio .Net suite used for developing application-level or document-level Add-ins for Microsoft Office Word, Excel, Access and Outlook Applications. Microsoft launched VSTO as an alternative to VBA.

    For more information regarding Excel Vsto Addin please visit the link below.

    Walkthrough: Creating Your First VSTO Add-in for Excel

    As other community members have already mentioned if you want to support more then one platform you can go for web addin but having limited functionality and feature in some area of development

    For more information regarding Excel Web Addin please visit the link below.

    Office Add-ins platform overview

    so as per your requirements you can decide which option is best suitable for you.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, May 31, 2016 2:52 AM
    Moderator
  • Thanks
    Tuesday, May 31, 2016 12:58 PM
  • Thanks Deepak for your reply.
    Tuesday, May 31, 2016 1:05 PM
  • Hi Dmitry,

    Thanks for your reply.

    I really appreciate that replied on my query, I want know more details about office add-ins that which feature of VBA/VSTO can be used through office add-ins and which are not.

    I will really appreciate if you can send me some more links specific about office add-ins.

    Best Regards,

    Divaker Pandey

    Tuesday, May 31, 2016 1:17 PM
  • I am not sure what you mean by "which feature of VBA/VSTO can be used through office add-ins and which are not".

    Once again, there are no VBA addins. VBA is what you get when you hit Ctrl+F11 - just a VB script that can use the Outlook Object Model. It is the same COM based object model used in straight IDTExtensibility2 or VSTO addins.

    Web addisn are JavaScript is the API is completely different. It is limited compared to the COM based API.


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

    Tuesday, May 31, 2016 2:10 PM
  • Hi Divaker Pandey,

    above you have ask the question

    which feature of VBA/VSTO can be used through office add-ins

    please visit the Excel Object Model. you can implement this model in VBA and VSTO code and use all the functionalities that provided by this model.

    Excel Object Model Overview

    if you think that any of the mentioned suggestion on this thread can help you to solve your issue then mark that suggestion as an Answer.

    if you still having a problem regarding this issue please let us know. so that we can provide you further help.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, June 1, 2016 7:23 AM
    Moderator
  • Hi Deepak,

    Sorry for confusion.

    Dmitty told in his reply that

    "Web addins run on all platforms, but the API currently  is extremely limited."

    "Web addisn are JavaScript is the API is completely different. It is limited compared to the COM based API."

    I want to know can i get a list which feature of VBA/VSTO Add-ins are not available  in Web Add-ins.

    In other words what else we can achieve/implement in web add-ins.

    As you know English is my second language so there may be issue in sentence making :)

    Regards,

    Divaker

    Thursday, June 2, 2016 11:22 AM
  • Hi Divaker Pandey,

    please visit the link below and select Excel from the sidebar menu.

    you will see all the objects with its description, syntax , examples are available there. with the help of that you can know which feature you can implement from which object. 

    JavaScript API for Office reference

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, June 3, 2016 5:25 AM
    Moderator
  • Thanks Deepak.

    I was searching for same list.

    Regards,

    Divaker

    Friday, June 3, 2016 12:35 PM
  • Dmitry,

    "VBA Add-ins" do exist. See: https://msdn.microsoft.com/en-us/library/office/gg597509(v=office.14).aspx

    In the Excel world they are extremely common, and have the .xla or .xlam extension.

    -Govert

    Excel-DNA - Free and easy .NET for Excel

    Sunday, August 7, 2016 1:00 PM
  • Ah, yes, thank you! I completely forgot about these Excel specific addins.

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

    Monday, August 8, 2016 2:57 AM
  • Among myriad other limitations, JavaScript web Add-ins do not support the ability to cancel any events. This is a major flaw/limitation in the model that prevents it from offering the ability for developers to create truly powerful and useful Apps on the new platform in any way similar to what is possible with COM Add-ins.
    Monday, August 8, 2016 4:49 PM
  • There is no such thing as VBA Add-ins. You can have a VBA module (script) and you can have COM addins.

    VSTO addins are COM addins - they just make addin development easier.

    If you do not plan to distribute your code, VBA would work.

    If you need to distribute your code to other users, COM addins (straight IDTExtensibility2 or VSTO) are the way to go.

    Web addins run on all platforms, but the API currently  is extremely limited.


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

    I just came across this post by accident and wanted to make an important technical correction.

    Regarding "There is no such thing as VBA Add-ins". This is 100% incorrect. VBA Add-ins are in fact the first add-in model developed for the Office suite of applications by Microsoft (over 20 years ago) and it still exists today. Many many many VBA add-ins exist in both the off-the-shelf and custom development markets. The latest XML format VBA add-ins (or Application Add-ins as Microsoft refers to them) have the extensions .xlam and .ppam and for Excel and PowerPoint respectively. For Word, .dotm can be used to add functionality in an add-in-like manner. They benefit from the fact that no additional tool chain is required (VBA IDE is built into Office) and often, no additional files/libraries are required other than the single application add-in file. They provide access to the fluent UI (ribbon, backstage etc.) but not UI panes.

    Secondly, regarding "If you do not plan to distribute your code, VBA would work." This is also incorrect. It is technically possible to distribute VBA-coded application add-ins either as a manual install, or within an EXE or MSI package. It's true that the process is not as easy as a COM add-in as it wasn't developed to do that but it is possible.

    Yes a VSTO/COM add-in is more powerful development options e.g. access to UI panes and newer controls. No it is not a development model supported by Mac (whereas VBA is).

    There are many advantages and disadvantages of developing a VBA add-in / COM add-in / Office Add-in. All have their uses as potential solutions to customer needs. VBA is still a very robust solution for developing an automation add-in whereas an Office Add-in (web) as very well suited to providing access to huge libraries of content or server-side applications that offload the processing needs of the app.


    Presentation specialist and VBA macro/add-in developer for PowerPoint http://youpresent.biz

    Monday, March 19, 2018 8:10 PM