From VBA to VSTO

by Dr. Gerard M. Verschuuren


Published by Holy Macro Books! Uniontown, OH

Order from MrExcel here: www.MrExcel.com
Order the book version here: www.Amazon.com
Order the e-Book version here: www.Amazon.com

•1 Visual Studio Tools for Office 
1.1 Why VSTO? 
1.2 The New Tool: VSTO 
1.3 The New Language: VB 

•2 Structure of the Tool (VSTO) 
2.1 The .NET Framework 
2.2 The Workspace (IDE) 
2.3 Connecting to Office Applications 
2.4 References 
2.5 What About Your Macros? 
2.6 Case Study: A Rosetta Stone 

•3 Structure of the Language
3.1 The Hierarchy of the Base Classes 
3.2 Core Objects 
3.3 Host Controls 
3.4 Case Study: A Rosetta Stone 

•4 Syntax Changes in VB
4.1 Properties 
4.2 Methods and Functions 
4.3 Events 
4.4 Case Study: A Rosetta Stone 

•5 Changes in Data Types and Scope 
5.1 Data Types 
5.2 New Arithmetic Operators 
5.3 Scope and Control Structures 
5.4 Case Study: A Rosetta Stone 

•6 Array Changes 
6.1 Regular Arrays 
6.2 Structured Arrays 
6.3 What happened to Variant Arrays? 
6.4 Case Study: A Rosetta Stone 

•7 Forms Instead of UserForms 
7.1 Form Class 
7.2 Form Elements 
7.3 Form Events 
7.4 The New ActionsPane 
7.5 Case Study: A Rosetta Stone 

•8 Error vs. Exception Handling
8.1 An Improved Alternative 
8.2 Some Debugging Issues 
8.3 Case Study: A Rosetta Stone 

•9 File Management 
9.1 Text Files 
9.2 Binary Files 
9.3 Dialog Controls for File Management 
9.4 Case Study: A Rosetta Stone 

•10 External Databases 
10.1 DAO Library 
10.2 ADO Library 
10.3 And Then There Is ADO 
10.4 Host Controls Revisited 
10.5 Dynamic Forms 
10.6 Case Study: A Rosetta Stone 

•11 Building Your Own Classes 
11.1 New Elements 
11.2 Real Inheritance 
11.3 Garbage Collection 
11.4 Case Study: A Rosetta Stone 

•12 Deployment and Security
12.1 Security 
12.2 Deployment 

•13 Migrating from VBA to VSTO 
13.1 VBA or VSTO? 
13.2 Automatic and/or Manual Migration 
13.3 Case Study: A Rosetta Stone 

•14 What Do You Need to Get Started? 
14.1 How, What, and When to Install? 
14.2 Useful Resources 
14.3 Are You Ready?