none
VSTO vs VBA RRS feed

  • Question

  • My organization is planning a utility to fetch data from SQL server and display in Excel(desktop only) for further analysis. We are using Visual Studio 2015 and Excel 2016(Office 365).

    Can someone please suggest which approach is best - VBA or VSTO?

    I would like to go for VSTO but not sure for how long it will be supported as Microsoft seems to be moving towards Apps for Office which is not appropriate for our requirement.

    Thanks,

    Amit


    • Edited by Amit_ Thursday, August 18, 2016 12:00 PM
    Thursday, August 18, 2016 12:00 PM

Answers

  • Hi Amit,

    you had mentioned that you have 2 choice. VBA and VSTO.

    but you are afraid that after some time maybe you don't get support for that.

    for this question I would like to inform you that you not need to worry at all regarding support.

    VBA and VSTO both are supported currently and also will be in future.

    As both the VBA and VSTO are available for the latest version of MS Office.

    you can choose the best suitable option as per your requirement without any confusion regarding support.

    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.

    • Marked as answer by Amit_ Friday, August 19, 2016 6:55 AM
    Friday, August 19, 2016 2:11 AM
    Moderator

All replies

  • Microsoft announced no plans to deprecate COM addins.  

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

    Thursday, August 18, 2016 3:32 PM
  • Hi Amit,

    you had mentioned that you have 2 choice. VBA and VSTO.

    but you are afraid that after some time maybe you don't get support for that.

    for this question I would like to inform you that you not need to worry at all regarding support.

    VBA and VSTO both are supported currently and also will be in future.

    As both the VBA and VSTO are available for the latest version of MS Office.

    you can choose the best suitable option as per your requirement without any confusion regarding support.

    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.

    • Marked as answer by Amit_ Friday, August 19, 2016 6:55 AM
    Friday, August 19, 2016 2:11 AM
    Moderator
  • Hallo Amit,

    same discussion here. There is at least one more point to consider. We have a plenty of Office docs with ActiveX Controls (since there are available in all Office apps) but we haven't found a way to handle their events yet.

    Replacing them by Windows Form Controls is not an option because they come with too many limitations:

    1) Limitations of Windows Forms Controls on Office Documents

    2) worst and there is no workaround: you can edit WFC only when zoom level = 100 %

    If you able to across those hurdles, please feel free to share. 

    Friday, August 26, 2016 9:45 AM