Mon premier blog

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

From Flash Fill to Best I can tell, Microsoft has not changed or deprecated any of our beloved client solution frameworks (VBA, COM add-ins, XLLs, EDFs, and VSTO). The authors—three of whom have been honored by Microsoft as Excel Most Valuable Professionals (MVPs)—show how to consistently make the right design decisions and make the most of Excel's most powerful new features. Content apps let you integrate web-based content within an Excel 2013 document. How to enable programmatic access to VBA in Excel 2007. Excel 2013 has plenty of new features. Just had my first encounter with VSTO, trying to embed a C# macro in an Excel workbook. Master VBA error handling, debugging, and performance optimization • Develop applications based on data stored in Access, SQL Server, and other databases • Build powerful visualization solutions with Excel charting engine • Learn how to work with VB. Yes, the concept is simple but the power it offers is not to be ignored. That the codes lives inside the document is really great! It's amazing how much you can do with the Excel OM and the VBA toolset. Probably the one of the best things compared to vsto solutions. Once inserted, they look like any other Excel object.