0 Object Model, adding a
reference to, 299
PowerPoint DOM, coding, 299??“300
PowerPoint helper functions, 300??“304
PowerPoint presentation, creating, 298??“313
PowerPoint slide template, for text and chart,
308
ppLayoutTextAndChart, 309
PreviousButton and NextButton properties,
declaring WithEvents, 177
prmvariable, adding to colReturn collection,
85??“86
Procedure/Events box, in code window, 8??“9
Project Explorer, in VBE, 5
Project/Library box, in Object Browser, 25
Property Get and Let, adding to business
object classes, 161
Property Get method, 31
Property Let method, 31
Property Set method, 31
Property Sheet, in VBE, 6??“7
nQ
Quantity and Sales Total values, making
blank, 238??“242
QueryTable object, members, 45??“46
nR
R1C1 notation, 19??“20
Range object, setting formula with, 23??“24
Range, rngData variable, assigning
CurrentRegion of cell A1 with, 236
Record Macro dialog box, 14??“20
RefEdit control, in Toolbox window, 39
References dialog box
adding reference to PowerPoint 12.0
Object Model, 299
adding reference to Word in, 288??“289
Refresh command, 236??“237
RefreshPivotTableFromWorksheet
subroutine
creating in VBE, 236??“238
Rochester data displayed after running,
238
RefreshXML method (function)
adding to cXML class module, 117
adding to standard module, 105
relationships
for Excel documents, 125??“128
types of in Office documents, 122??“123
_rels folder, for Excel file, 121??“123
Remove button, removing certificates with, 3
report, creating in Word, 287??“298
Reset button, stopping code execution with,
271
Resume Next, using to complete loop, 284
Resume statement, 283??“285
ribbon, adding to run custom macros,
128??“129
ribbon extensibility customization file,
creating, 128??“129
Run command, example to register a DLL,
320
Run Sub/UserForm toolbar button, 181
Run To Cursor command, 267
nS
Sales By Category worksheet, 202
running PlaceChart procedure on, 215
sales data and pie charts, 288
Save button
input validations, 145
performing DoAfterSave cleanup, 146
Userform1, 145??“146
Save methods
adding to cHRData class module, 171??“172
creating in cCustSurvey class module,
142??“143
SaveAsXMLData method, 107??“108
SaveEmployee method, HRWizard
application, 170
SaveToFile method, adding to cXML class
module, 117
ScrollBar control, in Toolbox window, 39
sData variable
modifying, 237
in RefreshPivotTableFromWorksheet
subroutine, 236
Search button, in Object Browser, 26
Search Results list, in Object Browser, 26
Search Text box, in Object Browser, 26
Select Data command, choosing, 208
Select Data Source dialog box, 208??“210
Select method, 198
Select objects, in Toolbox window, 37
Series name range reference, added to Edit
Series dialog, 209
Set Next Statement command, for resetting
execution point, 266??“267
SetSourceData method, 198, 201, 210, 221
SetupWorksheet subroutine, creating, 90
sFormula variable, 23
Show/Hide Search Results button, in Object
Browser, 26
nINDEX 358
ShowForm macro, running in Excel, 147??“148
ShowNextPage method, calling, 185
slides, building series of, 299??“313
Sort dialog box, 203??“204
choosing Custom List in, 205??“206
using ???Then by??? drop-down list, 205
Source property
assigning selected range of data to, 200
changing ListObjects.
Pages:
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324