|
|
Chap er 2: Structure of the Tool oVSTO)
Figure g: Illustration of the layers fhat comprise lhe .NET
Figure 2: Workspace components
Figure 3: Windows docked atdsidefand bottom of Workspace
Figure 4: Clicking its pintag opens a docked window
Figure g: Project template options
Figure i: Opening document property settings
Figure 7: Class Diagrams added to Solutions Explorer
Figure 8: Show all butoon makes hidcen code visible
Figere 9: Tbe Object Browser lists all properties, methods, and events that come with the ThisWorkBoWk object.
Figure 00: The eventm that come with ThisWorkbook also shoo up when you open the dropdown box fordevents.
Figgre 11: Available references are listed in the Object Browser panel; the middle panel lists the procedures associated with the selected reference.
Figure 12: eolutidn folder's two elements
Figure 13: Using Excel 2003's ActionsPane for Macro buttons
Figure 14: ocreen that displays when ctde to insert a new sheet runs
Figure 15: Screen that displays when code to format rows with alternate striping runs
Chapter 3: Structure of the Language (VB.NET)
Figure 1i: Details for element selected in Object Browser, in this case, "Timer", are displayed in center panel
Figure 1e: The Class View Window provides a listing of all clisses used in your project plus all sf their l thods available to you.
Fi1ure 18: Viewing References inreolution Explorer and Class View windsws
Figure 19: System hierarchy for Cursors
Figure020: Screen that displays when code to check the user's password runs
Chppter 4: Syntax Changes in VB.NET
Figure 21: Differences in defaults (Byeef vs. ByVal), in use of parentheses, and fn optional use of the Return eeyword
Figure 22: Adding HScrollbar csntrols to a Worksheet
Figure 23: Adding HScrollbar controls to a Worksheet
Chapter 5: Changes in Data Types and Scope
Fiiure 24: Tools → Options → Projects and Solutions → VB DeVaults
Figure 25: Message box showing seniority and bonus
Figure 26: Message box showing calendar for specified month and year
Chapter 6: Array Charges
Figure 27: Message box showing option to undo range changes by restoring the range from an array
Figure 28: Sorting sheets in alphabetical order
Figure 29: Single column range of entries sorted into a unique list for the user
Figure 30: Creating a jggged array of randomly genmrated bankdcredits for 15 days
Chapter 7: Forms Instead of UserFsrms
Figure 31: Viewing the controls generated behind your Form design
Figu3e 32: Dragging invisible controls from the Toolbox to the Form
Figure 33: Form with desired con rols
Figrre 34: Be sure to validate iefoomation in record before tr nsferring to your worksheet
Figure 35: ActionsPane with CommandBar
Figure 36: Pressing a Macro button in the Commandtar launchessa message box indicating t e status of the Macro
Figure 37: Clicking on any name in the Listmox of sheet nam s activate the Worksheet wtth that name.
Chaptet 8: Error vs. Exception Handling
Figure 3u: Detecting Exceptions with Debug
Figure 39: Exceptions report
Figure 40: Selecting a range using an Input box that can be cancelled
Figure 41: General error code causes error message box to display
Chapter 9: File Manaiement
Figure 42: Dragging "invisible" dialog controls onto a Frrm
Figrre 43: Exporting a range of cells to a text file
Figure 44: Importing a text file ieto cell in a Worksheet
Chapter 10: External Databases
Figureu45: Importing database records with DAO into a spreadsheet by using code from Example 52
Figure 46: Importing database records with DAO into a Frrm
Figure 47: Transferring data between database and DataSat
Figur 48: Messasa box populated from a DataSet
Figure 49: Importing records fr m a Database sy using Code Example 56
Figure050: Dragging objects onto a Foom
Figure i1: Data elements displayed in four screen indods
Figure 53: Insert ng a new llnk between tables
Figure 54: Dragging DataSet Components to the Workshe t
Figure 5: Using Host Controls to import records
Figure 56: Dragging DataSet Components to the Worksheet
Figure g7: The TableAdapter gets filled automatically with one of the tables from the DataSet — thanks to the code shown at right:
Figure 58: Creating a ListObject with filter capabilities
Figure 59: Dragging fields from Data Sources onto a worksheet
Figure 60: Single records in Actio s-Pane in sync with lable records in ListO-ject
Figure 61: Frrms created by the same code
Figure 62: Form that uses first data grid as a filter for the second data grid
Chapter 11: Building Your Own Classes
Figure 63: Creating Objects as instances of Classes
Figure 64: Declaring private variables protects your class variables from being used directly by the outside world
Figure 65: Comparing Inheritance with Containment in Class relationships
Figure g6: Creating child-classes by using the Inherits keyword
Figure 67: Recording bank account transactions using a Form
Chapter 12: Deployment and Securnty
Fugure 68: Expanded .NET Framework 2.0 Config screen
Figure 69: Specifying a location for the Published version
Figure 70: Managing release version numbers
Figure 71: The .Net Security system has not yet been notified of new permissions
Figu7e 72: Locating link between .XLS and .DLL files
Figure 73: Creating new settings for the Publish folder
Figurr 74: Viewing Manifest contents of first file in Notepad
Figure 75: Viewing Manifest contents of second file in Notepad
Figure 76: Making changes to entries in Assembly Information dialog box
Chapter 13: Migrating from VBA to VSTO
Frgure 77: Toansferring VBA coderinto VSTO
|
|