Table of Contents for Index

cAddress class module

Call Stack window, opening

call stack feature –2nd

Cancel button, coding

Cancel command button, code for Userform1

Candy chart, testing code for –2nd

cCustSurvey class module –2nd

coding into UserForm –2nd

cData class, code from ActiveX component –2nd

creating Save method in –2nd

validation results

cData class module

creating GetData function for

creating in VBE

initialization and termination methods

cData objects, using –2nd

cds.xml file, opening and adding new title to

cEmployee class

adding Property Let and Get functions –2nd

assigning property values –2nd

using –2nd

cEquipment class module

cExcelNwind class, code from ActiveX component

cExcelSetup class module

adding setup and cleanup functionality

setting and retrieving property values –2nd

creating in VBE

working with –2nd

cExcelSetup objects, using –2nd

cExcelUtils class

exporting file with new addition

exporting to UserForm.xlsm project –2nd

chart creation, getting started with –2nd

Chart object, placing into PowerPoint slide template

chart placeholder, getting location of

Chart Tools context ribbon

Chart01.xlsm, saving in macro-enabled format

ChartByRow macro –2nd

charting, in Excel 2007 –2nd

ChartObject objects

ChartObjects.Activate method, activating a chart with

ChartObjects.Count property

ChartType property, setting chart type using

CheckBox control, in Toolbox window

cHRData class, designing for HRWizard aplication –2nd

class library project, creating new –2nd

class modules –2nd

class name

class-based code, benefits of writing –2nd

classes, sample and usage –2nd

Classes list, in Object Browser

Class_Initialize method, for Employee class

Class_Terminate method, for Employee class

cleanup code

adding to cCustSurvey class module

adding to CreateChartSlidesText subroutine

adding to GetManagers subroutine

adding to MakeWordDoc subroutine

adding to ThisAddInShutdown method

adding to UserForm1

ClearForm procedure –2nd

client code, adding to !Northwind2Excel Object –2nd

cListManager class, adding methods

Close method, adding to btnSave_Click event

cmdCancel button's Click event, adding code to

cmdPrevious button's Click event

cmdSave_Click event, saving employee record with

code modules

adding to projects –2nd

standard –2nd

code window

fixing error in

in VBE –2nd

variable values shown in –2nd

with split panes

colParams collection, filling with ADODB.Parameter objects –2nd

colReturn collection, adding prm variable to –2nd

Column chart type, choosing

column headings, adding to worksheet

combo boxes, initializing –2nd

ComboBox control, in Toolbox window

command buttons, settings for –2nd

Command.Execute method, calling –2nd

CommandButton control, in Toolbox window

content types, in Office documents –2nd

[Content_Types]xml file

checking new parts in –2nd

for Excel file

controls, adding to forms –2nd

copy and paste method

Copy command, copying formulas with

Copy to Clipboard button, in Object Browser

CopyFromRecordset method

ADO error message

counter variable, determining formula location with

cPerson class module

adding call to ID Property Let function –2nd

adding read-only FullName property to –2nd

initializing and setting defaults

adding variable declarations to –2nd

finishing –2nd

Create PivotTable dialog box, sections in –2nd

CreateChartSlides subroutine, creating –2nd

CreateChartSlidesText subroutine

adding cleanup code to

adding variable declarations to –2nd

coding –2nd

CreateObject function –2nd

CreatePivotTable method –2nd

CreateTitleSlide subroutine, creating –2nd

cStep class module –2nd

cStepManager class module

adding properties to –2nd

designing to manage steps –2nd

properties table

Ctrl-drag, using fill handle with

CurrentMapName() method, adding to cXML class module

CurrentRegion property

currReturn variable, checking value of

Custom Lists dialog box

custom macros, adding ribbon to run –2nd

Customer Survey database, saving data to –2nd

Customer Survey form, launching

customUI .xml file, creating –2nd

cXML class

adding client code to test –2nd

adding properties to –2nd

building functions for –2nd

putting data on worksheets

D

DAO. See Data Access Objects (DAO)

DAO examples

adding reference to DAO library –2nd

importing Access data using Jet –2nd

importing Access data using ODBC –2nd

importing SQL data using ODBC –2nd

DAO Jet object model

DAO library, adding reference to –2nd

DAO objects, common –2nd

DAO ODBC

object model

result from Northwind Customers table

data access code, macro generated –2nd

data access component, creating –2nd

Data Access Objects (DAO), using in Excel 2007 –2nd

data entry form

creating simple –2nd

creating wizard-style UserForms –2nd

data import tools, in Excel 2007 –2nd

data orientation, switching from column to row –2nd

Data Preview window, with Text data type aplied

data range and legend information, defining and setting –2nd

Data ribbon, Sort command on

Data tab, Switch Row/Column command on

data table, formatting –2nd

DataAccessSample02.xlsm workbook, creating –2nd

DataAccessSample05.xlsm workbook, creating –2nd

DataBindings.LoadSettings method

DataRegionStart property, using –2nd

Debug menu

and toolbar commands –2nd

options for steping through code –2nd

Debug object

toolbar , 2nd

using –2nd

Debug.Assert method, sample subroutine using

Debug.Print method –2nd

DebugExample01.xlsm file

copying Debug.Assert subroutine into

downloading and opening

traping type mismatch error in –2nd

Debugger's toolkit –2nd

debugging and error handling –2nd

inserting breakpoint in code

loops

sample code for

VBE tools for simple –2nd

Department combo box, bound to named range

Details pane, in Object Browser

Developer ribbon, code options on

Developer tab, displaying

DisplayName property, fixing error fired by –2nd

DLL, using in project

DoClearSheet() subroutine, creating

docProps folder, for Excel file

DoHeadings method, adding titles to worksheet with –2nd

Dynamic PivotTable, creation code for

E

Edit Series dialog box –2nd

EmpData database worksheet

sample input values and saved data –2nd

sections in –2nd

employee data, adding to worksheet

Employee data type

employee record, saving –2nd

encapsulation

equipment information page, adding controls to

equipment tab control settings, table of

error handling –2nd . See also debugging and error handling; exception handling

breakpoint added in

debugging error handler

enabling for GetSalesTotal function

rules to live by

setting up procedure for

traping specific errors –2nd

type mismatch error –2nd

error messages, File Not Found

Excel, checking version of

Excel 2007

adding custom ribbon to workbook –2nd

adding ribbon to run custom macros –2nd

and ADO recordsets

changing code to classes in –2nd

charting in –2nd

data import tools –2nd

default charting behavior

importing XML into –2nd

in the .NET world –2nd

inside the XML file format –2nd

OOP solutions in –2nd

PivotTables feature in –2nd

simplifying code generated by –2nd

UserForms in –2nd

using ADO in –2nd

using DAO in –2nd

using XML in –2nd

Excel Options dialog box, Add-ins list in

Excel project, managed code in –2nd

Excel Trust Center. See Trust Center

Excel UserForm, creating –2nd

Excel Visual Basic Editor. See Visual Basic Editor (VBE)

Excel workbook, how it finds data –2nd

Excel worksheet, formatting

ExcelVersionShort property, checking Excel version with

exception handling, for GetData method

execution line text, at breakpoint –2nd

ExternalProcess, moving execution point back to

F

File Name property, changing –2nd

FileExists function, adding in VBE

FileNotFoundException, code to trap for

fill handle, using with Ctrl-drag

FindEmptyRow function

For...Next loop, for CreateChartSlidesText subroutine –2nd

Format Cells dialog box

FormatAtNumbersComma subroutine, running

FormatForm method, adding code for

Frame control, in Toolbox window

FullName property, adding to cPerson class –2nd

function –2nd

G

GetAccessData macro, creating –2nd

GetAccessData2 function, creating –2nd

GetChartInfo() subroutine –2nd

GetDAOAccessJet method –2nd

GetData method

complete code for –2nd

creating , 2nd –3rd

exception handling for

GetData subroutine, complete code for –2nd

GetEmpDept procedure, adding to cXML class module –2nd

GetEmpList function, creating –2nd

GetInitialCellSelection property –2nd

GetManagerEmployeeListSQL method, testing code with

GetManagerList

complete code for –2nd

result of running code

GetManagers subroutine

adding method calls and cleanup code to

creating

GetNewXMLData method

adding to cXML class module

modifying to use CurrentMapName –2nd

GetNextID method, adding to cCustSurvey class module –2nd

GetNorthwindData macro, running –2nd

GetObject function, syntax for using

GetRows method

GetSalesTotal function

adding a watch –2nd

adding error handler –2nd

adding Exit_Function line label to

adding Exit_Function to

code with error handling –2nd

using Error Resume Next –2nd

using to complete loop

variable list for

GetSelectedManagerEmployeeListSQL subroutine –2nd

GetSubjectBody function

inserting descriptive text from

GetTitle function, creating

GetTitleBody function, creating

GetXMLData function,

adding to cXML class module –2nd

copying into new workbook

Go Back button, in Object Browser

GetXMLData subroutine –2nd

GetXMLForExistingMap method –2nd

Go Forward button, in Object Browser

H

HasMaps property, adding to cXML class

Help button, in Object Browser

helper functions, creating for Word report –2nd

HR workbook

creating objects from cXML class in –2nd

testing code for

HRWizard

adding variables to cStepManager

class module in Project Explorer Class Modules folder

class modules table

classes –2nd

designing business objects

managing –2nd

testing –2nd

HRWizard UserForm

adding additional pages to –2nd

adding controls to –2nd

adding navigation to –2nd

adding variable declarations to

coding –2nd

initializing –2nd

running –2nd

HRWizard.xlsm file, EmpData database worksheet

HumanResources.uspUpdateEmployee PersonalInfo

M

macro

recording –2nd

writing in VBE –2nd

Macro Recorder,

and Code Modules –2nd

CreatePivotTable method called by

macro security

creating more –2nd

settings for–2nd

macro-enabled file types

macros, adding ribbon to run custom –2nd

maillist.csv

data imported from

with Comma selected as delimiter

with Tab selected as delimiter

MakeBeverageSalesChart macro

looking at code –2nd

modified version

recording –2nd

MakeDynamicPivotTable subroutine, creating –2nd

MakePieChart macro

for creating pie chart

modifying for Beverage category sales info –2nd

MakePieChart2 macro, creating and running –2nd

MakePivotTable macro

adding new worksheet to workbook in

code for –2nd

error generated by –2nd

saving as macro-enabled workbook

MakePowerPointPresentation subroutine

adding text to chart slides –2nd

completing –2nd

creating

modifying and running calling procedure –2nd

running the code –2nd

MakeWordDoc subroutine

adding charts to the report –2nd

managed code, in an Excel project –2nd

finished code for –2nd

message boxes, displaying information with –2nd

"Members of" list, in Object Browser

Microsoft Office object types –2nd

Microsoft tools, for creating Excel projects within VS 2005 –2nd

Microsoft Windows Vista, running examples on

Monthly Total Sales Amount worksheet, activating –2nd

MsgBox debugging, BirthYear function with –2nd

MsgBox function

arguments list

creating message boxes with –2nd

MultiPage control

adding command buttons to

determining what next page should be

hiding all pages except for first

in Toolbox window

inserting new page in –2nd

setting Value property –2nd

MultiPage1 control's Change event

N

navigation, adding to HRWizard UserForm –2nd

.NET

advantages of vs. ActiveX

in Excel 2007 programming

using to retrieve data –2nd

.NET components, using in Excel –2nd

New command button

code for UserForm1

testing

New Employee UserForm, creating –2nd

New Project dialog box, VS 2005 for MS Office 2003 projects

!Northwind2Excel Object –2nd

number format, changing

Number Format property

Nwind2Excel.dll

registering in Windows XP, 2000, or Vista –2nd

web site address for downloading

NWindData class module –2nd

NWindData.vb

adding code to class –2nd

changing class name to –2nd

NWindDataAccess project, adding to Solution Explorer

NWindDataAddIn project

NWindDataAddInSetup deployment project

NwindEmps01.xlsx file, downloading and renaming

O

object, definition of

Object box, in code window –2nd

Object Browser

displaying –2nd

window elements –2nd

Word objects displayed in

object-oriented programming (OOP)

overview –2nd

solutions in Excel –2nd

Wikipedia Object_database for

ODBC

importing Access data using –2nd

importing SQL data using –2nd

retrieving Access 2007 code via –2nd

running the code –2nd

Office 2007 Add-in projects, added in VSTO SE in Windows Vista –2nd

office integration –2nd

OLE DB (Object Linking and Embedding Database), successor to ODBC

OLEDB library, referencing

On Error GoTo statement

adding to turn on error traping

syntax for error handling

Open XML format, file container

Option Explicit –2nd

OptionButton, in Toolbox window

Options dialog box, showing VBE color options

Overwrite arguments, for apending XML data –2nd

P

PageSettings property, adding to cStepManager class –2nd

Parameter objects

apending to Parameters collection

creating ADO and adding to Command object

instantiating and setting properties

Parameters collection, apending Parameter objects to

personal information page, adding controls to –2nd

pie charts