Microsoft Office 2000 Development Book

A
absolute reference, 213
Access. See Microsoft Access
access to code, disallowing, 359
ADO (ActiveX Data Objects), 144, 146
    retrieving data from a data source, 150
    understanding OLE DB, 147
    using the object model, 148
    working with recordsets, 149
application
    distributing, 367
    packaging, 369
Application object model, 404
areas
    retrieving, 288
    working with the Selection object, 292
arguments, 70-72
Assistant, 319
    creating balloons, 322, 321, 325
    displaying a balloon, 323
    modifying, 320
automation tools, 6
AutoText, creating and inserting, 297, 298

B
balloons. See Assistant
bookmarks, 293
break mode, entering to debug, 47
breakpoint, setting, 47
built-in dialog boxes, 111

C
Call Stack, using to debug, 53
categories, managing a Web site, 394
cells ranges, 210
chart sheets, 241
Chart Wizard, 241
charts, 240, 241
    ChartWizard method, 245
    creating in Excel, 240-244
    embedded, 240
    modifying, 245
    sheets, 241
code
    adding to a procedure, 41
    adding to control events, 104
    recording, 37
    running, 42, 36
    stepping through, 48
    storing, 26
    using objects in, 88
    viewing in a macro, 38
    writing, 36
code librarian, 348
    adding code to, 350
    using code in, 352
code samples, 348
Code window
    adding code, 35
    opening, 34
COM add-ins, 353
    adding, 354
    building, 357
    creating, 371
    debugging, 355
    deploying, 368, 371
    registering a DLL, 356
command
    adding to Tools menu, 133
command bar
    adding controls, 120
    building, 114
    creating new, 118
    customizing, 113
    storing custom bars, 115
    working with, 124
CommandBar object model, 116
constants, 66-69
control events, adding code, 104
control toolbox, 96
controls
    adding to a document, 107, 110
    adding to a form, 98
    adding to command bars, 120
    initializing, 103, 105
    setting properties, 121
    validating input, 105
CreateObject, 90
custom setup, developing, 368
customizing menus and toolbars, 114

D
data
    creating charts in Excel, 240
    external, importing, 145
    retrieving from a data source, 150
    retrieving in an Office solution, 141, 173
    storing, 142
    using ADO, 146
    working with, 144
data access, 7
    handling errors, 171
data source
    establishing a connection, 150
    retrieving data from, 150
databases
    Excel vs. relational, 143
    reformatting, 144
    working in Access, 326
Debug.print statement, 50
debugging, 45
    Call Stack, 53
    COM add-ins, 355
    entering break mode, 47
    Immediate window, 49
    Locals window, 51
    tools, 53
    Watch window, 51
debugging tools, 53
declaring variables, 67
deployment
    choosing a strategy, 366
    COM add-ins, 368
    distributing custom templates and documents, 367
design
    considerations for Excel, 186
    considerations for Word, 274
    referencing a range, 203
design mode, running code, 42
developer resources, 347
developer tools, 346
developing a Web site, 382
dialog boxes, 111
digital certificates
    understanding security, 359
    using digital signatures, 361, 362, 364
distributing an application, 369
documents
    adding controls, 107, 110
    building in Excel, 185
    building in Word, 273
    creating and opening, 283, 286
    deploying a solution, 367
    inserting and formatting text, 294, 297, 298
    inserting data, 301
    printing, 287
    relating to projects, 28
    retrieving areas, 288
    saving and closing, 285, 288
    storing code in, 274
    using styles, 296

E
embedded charts, 240
environment options, setting, 36
Err object, 77
error handling
    data access errors, 171
    understanding the process, 75
event procedures, 37
events
    in Outlook, 335
    in Word, 279
    using the Workbook object, 195
    working with forms, 102
    worksheet events, 200
Excel. See Microsoft Excel
external data, importing, 144

F
files, importing to a Web site, 389
forms, 93, 100
    adding code to control events, 104
    adding controls, 98
    adding controls to a document, 107, 110
    control group, creating, 97
    initializing controls, 103, 105
    setting properties, 95
    Toolbox, adding pages, 98
    using built-in dialog boxes, 111
    working with events, 102
    working with the control toolbox, 96
formulas
    entering in Excel, 215
    referencing in Excel, 212
FrontPage. See Microsoft FrontPage
function
    CreateObject, 90
    GetObject, 89
Function procedure, 71

G
general procedures, 37
GetObject, 89

H
HTML
    coding with scripts in Excel, 257
    creating pages, 4
    publishing workbooks, 255

I
Immediate window, 49
    Debug.print statement, 50
Internet
    data access pages, 7
    Office Web components, 7

K
keyword, using New with Set statement, 89

L
labs
    setting up, iv
    viewing the solutions, 19
Locals window, 50

M
macros, recording, 38
menus, customizing, 113
methods, calling, 82
Microsoft Access
    object model, 327
    publishing an Access report, 329
    publishing a Web report, 328
    using the Simple Query Wizard, 166, 169
    working with databases, 328
Microsoft Excel. See also charts; PivotTables
    analyzing data, 262
    Application object, 190
    building documents, 185
    choosing a format for your solution, 260
    coding with scripts, 257
    design considerations for solutions, 186
    formula referencing, 212
    navigating the Excel model, 189
    object model, 187
    presenting results, 253
    publishing as Office Web components, 258
    publishing workbooks as static HTML, 254
    saving workbook files, 253
    understanding formula referencing, 212
    using from other applications, 190
    using objects, 189
    workbooks, 186, 192, 193
    worksheets, 197
Microsoft FrontPage
    Application object model, 404
    creating a personal Web site, 387
    creating a Web page, 388
    managing a Web site, 392
    Page object model, 411
    planning and developing a Web site, 380
    programming, 402
    publishing a Web site, 396
    server extensions, 383
    summarizing advanced features, 385
    using categories to manage, 394, 395
    using reports and tasks to manage, 392, 395
    using the object model, 412
    Web object model, 406
Microsoft Outlook
    adding dialog to an e-mail message, 336
    creating items, 333
    object model, 331
    using events, 335
Microsoft PowerPoint
    navigating the object model, 314
    publishing a Web presentation, 318
    understanding the object model, 314
    working with presentations, 315
Microsoft Word
    bookmarks, 293
    creating a template, 275, 286
    creating and inserting AutoText, 297, 298
    creating and opening documents, 284-86
    defining a Range object, 289
    design considerations, 274
    events, 279
    inserting and formatting text, 294
    inserting data, 301
    navigating the Word model, 278
    object model, 276
    printing documents, 287
    publishing a Web document, 288
    retrieving areas, 288
    saving and closing documents, 285
    storing code, 274
    styles, 296
    tables, 299
    working with the Selection object, 292
modules
    adding to a project, 40
    creating procedures in, 40
Move, describing methods, 157

N
naming conventions, 66

O
object library, referencing, 85
object models
    and ADO, 148
    CommandBars, 116
    Excel model, 187, 189
    Word model, 276, 278
    using in Office, 84, 90
object variable, declaring, 87
objects, 81
    calling methods, 83
    declaring a variable, 87
    in code, 88
    creating a Recordset, 152
    in Excel, 189, 187
    referencing a library, 85
    setting properties, 82
    understanding Workbook, 192, 195
    within Word, 278
Office 2000 suites, 8
Office 2000, creating solutions, 2
Office object models, 80
    hierarchy, 84
    shared, 85
Office solutions
    deploying, 14
    designing, 12
    understanding, 10
Office Web components, 7
OLE DB components, 147
Options, setting the environment, 36
Outlook. See Microsoft Outlook

P
Package and Deployment Wizard, 368
packaging an application, 369
Page object model, 411
Personal Macro Workbook, 186
PivotTables, 248-50
    modifying, 251
    understanding basics, 247
planning a Web site, 380
PowerPoint. See Microsoft PowerPoint
PowerPoint presentations, 314, 318
printing a document, 287
procedures, 40, 44, 70
    adding code, 41
    declaring with arguments, 72
    describing types, 37
program execution, controlling, 72
Programmability features, 6
project, displaying elements, 30
projects, relating to documents, 28
properties
    for controls, 121
    at design time, 32
    for forms, 95
    for objects, 82

Q
query. See also SQL
    building, 162
    using the Simple Query Wizard, 166, 169

R
range. See also Range object
    changing, 205
    collapsing, 291
    direct referencing in Excel, 210
    selecting, 210
    redefining in Word, 291
    referencing at design time, 203
    returning, 203
    using Cells property, 203
Range object, 203
    defining in Word, 289
    defining named ranges in Excel, 219
    entering values and formulas in Excel, 215
    formatting in Excel, 211
    formula referencing in Excel, 212
    returning recordset data to a worksheet, 221
    working with, 218
records
    filtering in a recordset, 160
    navigating in a recordset, 156
recordsets
    creating, 152, 160
    filtering records, 160
    navigating records, 156
    opening using SQL, 167
    populating controls, 156
    referencing fields, 155
    working with, 149
reference
    relative, 213
    setting to ADO, 149
    styles, 213
    using the Cells property, 203
    working with cell ranges, 210
reference styles, 213
relational databases, storing data, 142
relative reference, 213
Reports, viewing, 392
Resume statement, 76
retrieving data in Office, 141
run mode, running code, 42
run-time errors, handling, 75

S
scope of variables, 68
security
    mechanisms, 360
    settings, 363
selecting, compared to direct referencing, 210
Selection object, working with, 292
server extensions, 383
setup, developing a custom program, 368
signing your project digitally, 362
Simple Query Wizard, 166, 169
solutions
    creating, 2
    deploying, 14
    designing, 12
    understanding, 10
SQL, 162
    opening a recordset, 167
    selecting records, 163
    using the Simple Query Wizard, 166, 169
storage location, custom command bars, 115
styles, using in documents, 296
Sub procedures, 70

T
tables, 299
Tasks list, 392
templates
    deploying a solution, 367
    using in Excel solutions, 186, 212
    creating in Word, 275, 286
    storing code in, 274
toolbox, 96
Tools menu, adding commands, 133

U
user interface, building, 128

V
values, entering, 215
variables, 66
Visual Basic Editor, 25, 29, 56
    creating general procedures, 40
    features, 29
    relating projects to documents, 28
    setting Options, 36
    storing code, 26
    understanding basic elements, 30
Visual Basic for Applications, 3
Visual Basic syntax, 78
    controlling program execution, 72
    handling run-time errors, 75
    procedures, 70
    variables, 66

W
Watch expression, adding, 52
Watch window, 51
Web components
    Office, 7
    publishing results, 258
Web document, publishing, 288
Web object model, 406
Web page, creating and importing, 388, 390
Web presentation, publishing, 318
Web report, publishing, 328
Web site
    creating, 384
    displaying the structure, 409
    importing files, 389
    managing with categories, 394, 395
    managing with folders and files, 408
    managing with reports and tasks, 392, 395
    navigating, 408
    planning and developing, 380
    publishing, 396
With statement, 83
Word. See Microsoft Word
workbook
    opening, 192
    publishing as static HTML, 254
    saving and closing, 193, 253
    using events, 195
    using templates, 212
worksheet events, writing code, 200
worksheets, 197, 201
    activating, 199
    adding, 197
    managing, 199
    changing a range, 205
    referencing a range, 203
    returning Range objects, 203, 208
    using events, 200