Mon premier blog

From VBA to VSTO: Is Excel's New Engine Right for You? Gerard M. Verschuuren
Publisher:

Office 2003 came with Scripting Engine based on Javascript (not successful) and since then promoting the use of VSTO and Office PIAs in . This Excel user's guide to VSTO—the new Excel Macro programming language being promoted by Microsoft—shows how to perform the equivalent VBA actions with VSTO. While these features are extremely powerful and by far irreplaceable by using any other development option, here are several reasons why you should not considering VBA as an option for your new project. It's amazing how much you can do with the Excel OM and the VBA toolset. Microsoft is planning to retire VBA for while. Probably the one of the best things compared to vsto solutions. Between these two extremes, I would like a simple workaround to simply automate the PowerPivot Refresh operation from VBA/VSTO. That the codes lives inside the document is really great! They know they might have to rewrite part of their add-in for every new version of PowerPivot, and in case of any issue, they cannot rely on Microsoft support. Net is equally good and can used if you are already an expert in classic VB. Otherwise, you should use XMLA connecting directly to the sandboxed engine.