From VBA to VSTO: Is Excel’s New Engine Right for You?

This book is for those who wonder whether they should transit from Excel/VBA to Excel/VSTO. It was not written for people who want to learn programming in Excel, nor was it written for those (professional) developers who want to know all the ins and outs of VSTO programming.

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. The differences between the VSTO and VBA development environments are explained, helping Excel users decide if they should embrace VSTO or seek out other technologies.

My only intention is to help VBA users to make the right decision as to whether they should transit to VSTO and, if they decide to do so, to be aware of the hurdles they have to leap and the benefits they will reap.

Therefore, in this book I focus on the differences between both programming languages by explaining where they diverge and by showing examples of code on both sides of the transition line.

By using so-called Rosetta stones, I show you, using some carefully selected examples, where the two languages differ.

My hope is that this book will be a helpful guide in making a well-balanced decision in this matter and, if you do venture the transition, that it will smooth the process that lies ahead of you.

TABLE OF CONTENT:
Chapter 01 - Visual Studio Tools for Office
Chapter 02 - Structure of the Tool (VSTO)
Chapter 03 - Structure of the Language (VB.NET)
Chapter 04 - Syntax Changes in VB.NET
Chapter 05 - Changes in Data Types and Scope
Chapter 06 - Array Changes
Chapter 07 - Forms Instead of UserForms
Chapter 08 - Error vs. Exception Handling
Chapter 09 - File Management
Chapter 10 - External Databases
Chapter 11 - Building Your Own Classes
Chapter 12 - Deployment and Security
Chapter 13 - Migrating from VBA to VSTO
Chapter 14 - What Do You Need to Get Started?

Download here

Password: ganelon