| < Day Day Up > |
|
Object box in Code window, 43
Object Browser, 326
listing dialog box constants, 389
locating events, 277
Object Browser window, 44, 45
object collections, 79
object levels in a chart, 326
object model, 107, 108
object references, characterizing as properties, 300
object variables, 301
creating, 455
creating charts as, 323
declaring, 72
defining, 72
objects with multiple, 303
referring to applications, 451
setting to uninitialized state, 302
Object_Change event procedure, 265
object-oriented programming, 25-28
objects, 26, 42, 299
accessing, 301
actions performed by, 119
adding to a collection class, 314
adjusting vertical spacing among, 46
aspects of, 26-28
automating, 465
centering on a form, 46
containing, 107
creating, 300, 301
declaring, 302
deleting all in a collection, 315
destroying, 302, 311
exposing common directly, 108
formatting, 219-37
grouping selected, 46
instantiating, 301
interface to, 304
lining up along a common border, 46
monitoring the state of, 300
with multiple object variables, 303
naming, 43
Nothing value and, 302
as nouns, 300
removing groupings, 46
representing a collection of similar things, 300
resizing, 46
supported by particular events, 277
used to control Excel, 107
validating information in, 317
working with, 107
Objects folder, 42
Object_SelectionChange event procedure, 265
ObjectVariable Is Not Nothing expression, 302
ODBC
connection string, 352
data provider for, 486
Office applications, 445
add-ins spanning multiple, 259
interacting with, 455-60
Office Clipboard, 20
Office documents, publishing to the Web, 535
Office Marketplace, 8
Office Object Model, 281
Office objects, 457
Office Web Components. See Web Components
Offset property, 167-69
OK button, 68
OLAP database, 347, 348
OLAP property of PivotCache object, 353
OLAP server, 347
OLE Automation. See Automation
OLE DB call, translating, 486
OLE DB connection string, 352
OLE DB data type, 494
OLE DB protocol, 481
On Error command, 82
On Error Resume Next statement, 314, 380, 513
On Error statement, 360
OnAction event, testing, 379
OnAction property, 374, 375
OnAction routine, 400
OnAddInsUpdate method, 248, 249
OnBeginShutdown method of IDTExtensibility2 interface, 248, 249
OnBeginShutdown routine, 261
OnConnection method, 252
of IDTExtensibility2 interface, 248
passing the application object to, 259
OnConnection routine, 260
OnDisconnection method, 249, 252
OnKey method, 125-27
OnLine Analytical Processing server, 347
OnStartupComplete method, 249
OnStartupComplete routine, 260
Open dialog box, 120, 291
Open event, 268, 269, 433
open files, checking for, 134
Open method
of Application object, 295
of Connection object, 484
of Documents collection, 458
opening a connection to a database, 513
opening existing Web pages, 528
of Recordset object, 492, 514
of Workbooks collection, 130-31
Open statement of VBA, 295
OpenText method of Workbooks, 132-34
OpenWriteExcelWbkContents procedure, 463
operating system
for a text file, 133
for a workbook, 130
Operator property, 188
Option Base statement, 64
Option Explicit statement, 254
Option Private Module statement, 91
Option Private statement, 86, 99
optional parameters, not allowed in events, 310
OptionButton controls, 409, 431
Options dialog box, 50-52
Color tab, 224, 226
Custom tab, 224
displaying, 48
options for a wizard, 438-40
Or operator, 473
Oracle databases, connecting to, 486
Order By clause, 475, 493
Order item on the Format menu, 46
Organize Supporting Files in a Folder check box, 522
Orientation property
of PageSetup object, 154
of PivotField object, 353, 355
of ScrollBar control, 411
Origin parameter
of Open method, 130
of OpenText method, 133
OriginalValue property, 494
Other parameter, 134
OtherChar parameter, 134
outline format, specifying, 355
Outlook, adding a reference to, 452
Outlook Calendar, 450, 452
Outlook Contacts folder, 453
Outlook Object Library, 452
out-of-process components, 248
output parameter to a stored procedure, 490
OverWrite alert, 116
| < Day Day Up > |
|