Add methods, 47
spacer variable, 213
SpinButton control, in Toolbox window, 39
Split bars, in Object Browser, 27
SQL data
importing using ADO, 67??“73
updating, 80??“87
SQL Server 2005 Management Studio
Express, installing, 67??“68
Standard Module1
creating GetChartInfo() function on, 216
opening, 254
StartWizard macro, running, 189
Static Macro Recorder-Generated PivotTable
Creation, code for, 234
Step Into command, 264??“265
Step Out command, 265
Step Over command, 265??“266
StoreData method, function of, 183??“185
subprocedures (subroutines), 28
adding cleanup code to MakeWordDoc,
293
adding InitLists, 180??“182
CreateChartSlidesText, 308??“313
creating CreateChartSlides, 302??“304
creating CreateTitleSlide, 300??“302
creating DoClearSheet, 95
creating InitForms, 180??“182
creating TotalSales, 21
FormatAtNumbersComma, 242
GetChartInfo, 216??“217
GetData, 338??“339
GetManagers, 95??“96
GetSelectedManagerEmployeeListSQL,
77??“80
GetXMLData, 276
InitWizard, 179??“180
MakeDynamicPivotTable, 233??“235
MakePowerPointPresentation, 300,
304??“306, 308??“313
MakeWordDoc, 291??“298
PlaceChart, 213??“215
PlaceChartDynamic, 217-220
PlaceData, 347
RefreshPivotTableFromWorksheet,
236??“238
SetupWorksheet, 90??“91
TotalSales, 21
Summary field headings, modified, 245
nT
table default version, defined by
CreatePivotTable method, 230
table name, defined by CreatePivotTable
method, 230
table placement, defined by
CreatePivotTable method, 230
TabStrip control, in Toolbox window, 38
task pane, creating custom using .
Pages:
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324