NET world, 323??“349
inside the XML file format, 119??“131
OOP solutions in, 87??“96
PivotTables feature in, 223??“247
simplifying code generated by, 46??“48
UserForms in, 133??“191
using ADO in, 67??“87
using DAO in, 54??“67
using XML in, 99??“132
Excel Options dialog box, Add-ins list in, 341
Excel project, managed code in, 327??“349
Excel Trust Center. See Trust Center
Excel UserForm, creating 344??“348
Excel Visual Basic Editor. SeeVisual Basic
Editor (VBE)
Excel workbook, how it finds data, 340??“341
Excel worksheet, formatting, 338
ExcelVersionShort property, checking Excel
version with, 74
exception handling, for GetData method, 338
execution line text, at breakpoint, 263??“267
ExternalProcess, moving execution point
back to, 265
nF
File Name property, changing, 331??“332
FileExists function, adding in VBE, 277
FileNotFoundException, code to trap for, 338
fill handle, using with Ctrl-drag, 18
FindEmptyRow function, 139
For...Next loop, for CreateChartSlidesText
subroutine, 309??“310
Format Cells dialog box, 242
FormatAtNumbersComma subroutine,
running, 242
FormatForm method, adding code for, 346
Frame control, in Toolbox window, 38
FullName property, adding to cPerson class,
164??“165
function, 28??“29
nG
GetAccessData macro, creating, 43??“46
GetAccessData2 function, creating, 46??“47
GetChartInfo() subroutine, 216??“217
GetDAOAccessJet method, 57??“59
GetData method
complete code for, 334??“335
creating, 95, 337??“341
exception handling for, 338
GetData subroutine, complete code for,
338??“339
nINDEX 354
GetEmpDept procedure, adding to cXML
class module, 113??“117
GetEmpList function, creating, 81??“82
GetInitialCellSelection property, 89??“90
GetManagerEmployeeListSQL method,
testing code with, 73
GetManagerList
complete code for, 75??“76
result of running code, 77
GetManagers subroutine
adding method calls and cleanup code to,
96
creating, 95
GetNewXMLData method
adding to cXML class module, 111
modifying to use CurrentMapName,
112??“113
GetNextID method, adding to cCustSurvey
class module, 141??“141
GetNorthwindData macro, running, 322??“323
GetObject function, syntax for using, 292
GetRows method, 74
GetSalesTotal function
adding a watch, 273??“275
adding error handler, 279??“282
adding Exit_Function line label to, 280
adding Exit_Function to, 279
code with error handling, 281??“282
using Error Resume Next, 284??“285
using to complete loop, 284
variable list for, 279
GetSelectedManagerEmployeeListSQL
subroutine, 77??“80
GetSubjectBody function
creating, 290??“291
inserting descriptive text from, 309
GetTitle function, creating, 290
GetTitleBody function, creating, 290
GetXMLData function,
adding to cXML class module, 111??“112
copying into new workbook, 105
creating, 99??“100
GetXMLData subroutine, 276??“278
GetXMLForExistingMap method, 111??“ 112
Go Back button, in Object Browser, 26
Go Forward button, in Object Browser, 26
nH
HasMaps property, adding to cXML class, 109
Help button, in Object Browser, 26
helper functions, creating for Word report,
290??“291
HR workbook
creating objects from cXML class in,
117??“119
testing code for, 119
HRWizard
adding variables to cStepManager, 173
class module in Project Explorer Class
Modules folder, 178
class modules table, 161
classes, 160??“161
designing business objects, 169
managing, 172??“178
testing, 188??“191
HRWizard UserForm
adding additional pages to, 153??“154
adding controls to, 154??“160
adding navigation to, 183??“186
adding variable declarations to, 178
cleaning up, 188
coding, 178??“191
controls table, 154??“155
initial layout for, 153
initializing, 178??“182
laying out, 152
opening, 188
running, 181??“182
HRWizard.
Pages:
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324