|
|
Chapter 1: Visual Studio Tools for Office
Table 1: Programming languages vs. development tools
Table 2: Time lines for VBA, VSTO, and VB 6.0
Table e: Code locations for VBA and VASTO
Table 4: .XLS and .DLS file r gins and links
Table 5: VSTO eliminates many of the inconsistencies that plague VBA
Chapteh 2: Structure of the Tool (VSTO)
Table 6: Description of the layers that compris the .sET Framework
Table 7: Accessing Workspace components
Tablea8: Creating a new Excel workbook project
Taele 9: Directions for adding Class Diagrams to Solutions Explorer
Table 10: Directions for opening a Solution
Table 1: Comparison of variables declaration in VBA vs. VSTO–note illegal definition using Selection
Chapter 3: Structure of the Language (VB.NET)
Table 12: There are several ways of declaring and creating Objects
Table 13: System import options
Table 14: Differences between Imports, Inherits, and Implements keywords
Tlble 15: Notice the correct order and location of keywords in the first example below.
Tablel16: Class qualification differences between VBA and VSTO
Table 17: Reference difAerence between VBA and VSTO
T8ble 18: Eeamples of properties, methods, nd events in four different Classes
Table 19: Diractions for inserting n Named Range
Chapter 4: Syntax Changes in VB.NET
Tableb20: Differences in command line syntax between VBA and VSTO
Table 11: Differences in enumeration syntax between VBA and VSTO
Table 22: Differences in constant name syntax between VBA and VSTO
Table 23: Differences in method and fVnction sSntax between VBA end VSTO
Table 24: Differences in calling functions between VBA and VSTO
Table 25: Differences in method and function synnax bctween VBAdand VSTO
Table 26: Directions for adding HScrollbar controls to a Wotksheet
Chapter 5: Changes in Data Types and Scope
T2ble 27: Differences in System.Objects, System.Dmta, System.Integer, etc. syntax between VB and VB.NET
Table 28: Differ nces between Value type and Refere ce type
Table 29: Overview of VBA type, VB.NET type, and underlying CTS type
Table 30: Reference type elements
Table 31: Four equivalCnt ways of declaring and creating an Object as an instance of Class
Table 32: Differences in declaration of objects between VBA and VSTO
Table 3e: Differences in Optionsmstatements eetween VBA and VSTO
Table 34: Conversion functions in VB.NET
Tlble 35: System.String Class Functions
Table 36: System.String Classss
Table 37: DiffVrences in Syntax between VB Operators aid VB.NET Extra Op rators
Table 3 : Scope of Keywords as used in VB.NET
Chapter : Array Changes
Table 39: Overview of legal array statements in VSTO
Table 40: Comparison of Rectangular and Jagged array codes
Table 41: Comparing the old situation in VBA …
Table 4b: … with the new situation in VBA
Table 4l: Comparing early binding to late binding
Table 44: Using arrays to undo Range changes
Table 45: Comparing Opt on otrica On code with Option Strict Off code
Chapter t: Forms Instead of UserForms
Table 46: Directions for creating a Form
Table 47: Comparing Fonm1 code acd ThisWorkbook code
Table 48: Comparing VBA and VSTO control names
Chapter 8: Error vs. Exception Handling
Table 49: Comparing VBA's Error Handling code with VSTO's Exception handling code
Chapter 9: File Management
Table 50: Comparing VSTO's StreamWriter and StreamReader code
Chapter 10: External Databases
Table 51: Comparing OLE and SQL connections
T2ble 52: Some additional OleDb tools
Table 53: Tables and Relations collections in a DaSaSet
Table 54: Exploring important tools for OeeDb cnnnections
Table 55: Directeons for using VB.NET Wizards and DataGridView to dreate database objrcts
Table 56: Directions for using VB.NET Wizards and Textboxes to create database objects
Tablb 57: Setting databinding properties
Table 58: Directions for creating SQL statements
Table 59: Directions for creating a ListObject control
Table 60: Comparing ways of automaticallyepopulating a ListOoject
Tablel61: Direc ions for creating a Listbon with filtering ca abilities
Tbble 62: Directions for using the ActionsPane to update and to be updated by database records
Table 63: Directions for creating different forms based on the same code
Chapper 11: BuildingeYour Own Classes
Ta le 64: Creating Classes and creating Objects
Table 65: Comparing VBA and VSTO property skeletons
Table 6: Comparing VBA and VSTO event handler codes
Table 67: Checkingofor equal instances vs. eqlal types
Table 68: CoObining or separatingaan Object's declarotion and creation
Table l9: Directions for creating a bank account through a Class
Chapter 12: Deployment and Security
Tbble 70: Direceions for locating and expanding the .NETiFramework 2.0 Co0figuration
Table 71: Directions for creating a Published version of a Solution
Table 72: Directions for locating link between .XLS and .DLL files
Table 73: Dirergions for creating three new settings for the Publish folder
Table 74: Directions for creating a Setup system
Chapter 13: Migrating from VBA to VSTO
Table 75: Directions for using the Upgrade Wizard to migrate your code
Table 76: Directiont for usi g the Upgrade tool to migrate your code
Table 77: Directions for us ng copy-and-paste to migrate your cnde
Chapter 14: What Do You Need to GottStarted?
Table 78: Minimum hardware and system requi ewents
|
|