none
Is there any difference in functionality available between VBA addins and Html+JS addins RRS feed

  • Question

  • HI

    Just want to nut out if there is any reason to use one style of Office development over another, does a VBA addin have access to any internals in Excel that HTML + JS does not?

    This article covers HTML+JS well but not any mention of VBA https://dev.office.com/docs/add-ins/overview/office-add-ins

    If there was no functional difference then the HTML+JS version would have more scope to work with Excel Online as well I would think, I am still just seeing Addins developed in VBA and wondering if there is a reason for it?

     


    Taking my C# further

    Tuesday, January 10, 2017 3:54 AM

Answers

  • The Excel-JS API is developing rapidly but at the moment is much more restricted than the VBA COM API.

    Also it uses an asynchronous out-of-process architecture that is currently considerably slower than COM.

    But if you want to develop an Excel application that runs both online and on various end-points then Excel-JS is the way to go.


    Charles Excel MVP The Excel Calculation Site http://www.decisionmodels.com/

    • Marked as answer by SaythJ Wednesday, January 11, 2017 8:07 AM
    Tuesday, January 10, 2017 12:49 PM

All replies

  • The Excel-JS API is developing rapidly but at the moment is much more restricted than the VBA COM API.

    Also it uses an asynchronous out-of-process architecture that is currently considerably slower than COM.

    But if you want to develop an Excel application that runs both online and on various end-points then Excel-JS is the way to go.


    Charles Excel MVP The Excel Calculation Site http://www.decisionmodels.com/

    • Marked as answer by SaythJ Wednesday, January 11, 2017 8:07 AM
    Tuesday, January 10, 2017 12:49 PM
  • Hi SaythJ,

    As other community member already suggested you.

    both JavaScript addin and VBA addin have their own advantages and disadvantages.

    the object model for both JavaScript Addin and VBA Addin are different.

    VBA have much more powerful object model. so that you can use more functionalities to develop your addin.

    currently JavaScript object model provide limited features and functionality.

    VBA Addin cannot run online but javascript addin can run online and with different platforms.

    so you can try to refer both the object models and try to know the difference between them.

    if you have any further question then let me know about that. I will try to suggest you further.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, January 11, 2017 1:52 AM
    Moderator