From VBA to VSTO - Is Excel's New Engine Right for You?

Table of Contents
Back Cover
From VBA to VSTO - Is Excel's New Engine Right for You?
Prologue
Chapter 1: Visual Studio Tools for Office
- 1.2 The New Tool: VSTO
- 1.3 The New Language:
Chapter 2: Structure of the Tool (VSTO)
- 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
Chapter 3: Structure of the Language (VB.NET)
- 3.2 Core Objects
- 3.3 Host Controls
- 3.4 Case Study: A Rosetta Stone
Chapter 4: Syntax Changes in VB.NET
- 4.1 Properties
- 4.2 Methods and Functions
- 4.3 Events
- 4.4 Case Study: A Rosetta Stone
Chapter 5: Changes in Data Types and Scope
- 5.2 New Arithmetic Operators
- 5.3 Scope and Control Structures
- 5.4 Case Study: A Rosetta Stone
Chapter 6: Array Changes
- 6.2 Structured Arrays
- 6.3 What happened to Variant Arrays?
- 6.4 Case Study: A Rosetta Stone
Chapter 7: Forms Instead of UserForms
- 7.2 Form Elements
- 7.3 Form Events
- 7.4 The New ActionsPane
- 7.5 Case Study: A Rosetta Stone
Chapter 8: Error vs. Exception Handling
- 8.2 Some Debugging Issues
Chapter 9: File Management
- 9.2 Binary Files
- 9.3 Dialog Controls for File Management
- 9.4 Case Study: A Rosetta Stone
Chapter 10: External Databases
- 10.1 DAO Library
- 10.2 ADO Library
- 10.3 And Then There Is ADO.NET
- 10.4 Host Controls Revisited
- 10.5 Dynamic Forms
- 10.6 Case Study: A Rosetta Stone
Chapter 11: Building Your Own Classes
- 11.2 Real Inheritance
- 11.3 Garbage Collection
- 11.4 Case Study: A Rosetta Stone
Chapter 12: Deployment and Security
- 12.2 Deployment
Chapter 13: Migrating from VBA to VSTO
- 13.2 Automatic and/or Manual Migration
- 13.3 Case Study: A Rosetta Stone
Chapter 14: What Do You Need to Get Started?
- 14.2 Useful Resources
- 14.3 Are You Ready?
Index
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y-Z
List of Figures
List of Tables
List of Code Examples