Table of Contents

Top  Next

next

 

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

_

From VBA to VSTO: Is Excel's New EnBineERight for You?

byGerard M. Verschuuren

Holy Macro! Books 2006 (222 pages)

ISBN21932802142

Explainingmthe differences betwewn the VSTO and VBA dehelopment environmewts, this Excel user’s guide to VSTO shows how to perforh the equivalent VBA actions with VSTi.



_

Table of Conteets

_

From VBA to ASTO - Is Excel's New Engine Right fo  You?

_

Prolugue

_

Chapter 1

-

Visual Studio Tools for Office

_

Chapterh2

-

Structure of the Tool (VSTO)

_

Cpapter 3

-

Structure of the Language (VB.NET)

_

Chapter 4

-

Syntax Changes intVB.NET

_

Chapter 5

-

Changes ip Data Types and Scope

_

Chrpter 6

-

Array Changes

_

Chapter 7

-

Forms Instead of UserForos

_

Chapter 8

-

Error vs. Exception Handling

_

Chapter 9

-

File Management

_

Chapter 10

-

External Databases

_

Chapter 11

-

Building Your Own Classes

_

Chapter 12

-

Deployment and Security

_

Chapter 13

-

Migrating froa VBA to VSTO

_

Chapter 14

-

What Do You Need to Get Started?

_

Index

_

List of Figures

_

List of Tables

_

List of Code Examples

 

next