Index_O

O

object browser, 72-73, 129-34. See also object libraries

finding dialog constants in, 388

overview, 129-30

object catalog, 367

object libraries, 72-73

Excel 97, 58

Excel 2000, 131

Excel 2002, 131-32

providing references to, 132-33

Object Linking and Embedding. See OLE (Object Linking and Embedding)

Object variables , 88, 95

objects, 7, 8, 123, 124

accessing, 471

active objects, 128

objects clarified with keyword With, 134-35

changed and extended, in Excel 97, 56-57

connections between, 649

default, 125

distinguishing from methods and properties, 125-27

drawing, 560-64

embedded, 776-77

enumeration, 801-2

in Excel 2000, 52

hierarchy, 794

linked, 777

nesting, 471

properties of multiple, 802

references to other workbooks, 133-34

syntax summary, 138-39

obj. testmethod ( ), 129

ODBC data source, 627, 652-53

ODBC documentation, 640

ODBCError object, 835

ODBCErrors object, 835

Office 2000, 9, 229

Office 2002, 646

Office Assistant, 54

Office Binder Library, 59

Office Developer, 318, 736

Office documents, 59

Office Library, 49, 59, 801

Offset method, 37, 187, 189, 191, 660

Offset(row, column) method, 37

OK button, deactivating , 37

OLAP (Online Analytical Processing) cube files, 628, 704-7

Olap.cub file name , 722

olap-cube worksheet, 710

OLE (Object Linking and Embedding)

in ActiveX automation, 761-63, 769-70

fundamentals, 775-76

OLE objects

editing

with ActiveX automation, 777-79

with OLEObjects method, 776-77

inserting new, 779-80

linking, 780

properties of, 789

OLE-DB driver, 652-53

OLEDBError(s) object, 835

OLEFormat object, 560, 835

OLEObject object, 835-36

OLEObjects method, 776, 777, 779

OLEObjects object, 836

On Error command, 373

GoTo Label variant, 381-83, 386

GoTo variant, 383, 386

Resume Next variant, 380-81, 386

On Error Resume Next command, 23, 223, 515

OnAction event, 158

OnAction property, 147, 469, 470

OnCalculate event, 158

OnData event, 158

OnDoubleClick event, 158

OnEntry event, 158

one-to-one relation, 622

OnEventXxx procedures, 63, 143

OnEventXxx properties, 140, 142

OnKey event, 158

OnKey method, 142, 148

Online Analytical Processing (OLAP) cube files, 628, 704-7

on-line help. See help system

OnRepeat event, 158

OnRepeat method, 142, 148

OnSheetActivate event, 158

OnSheetDeactivate event, 158

OnTime event, 158

OnTime method, 142, 149-50

OnUndo event, 158

OnUndo method, 142, 148

OnWindow event, 158

Open command, 278-79, 280

Open event, 145, 157

Open method, 216, 276, 647, 650, 651, 666, 667

OpenAsStream method, 302

opening

files, 140, 145

workbooks, 221

OpenSurveyDatabase, 679

OpenText method, 54, 63, 289-92

OpenTextFile method, 301

operating mechanisms, for freestanding applications, 485

operators, 175-78

Optimize Memory option, 709

optimizing speed of procedures, 356-57

Option Base 1 field, 96

Option Base instruction, 93

option buttons , 419-20

Option Compare Binary instruction, 240

Option Compare Text instruction, 238

Option Explicit instruction, 78, 86, 87

Option Private Module instruction, 108, 111

Option Private Module keyword, 112

Optional keyword, 103

OptionButton object, 836

OptionExplicit instruction, 372-73

options. See also names of specific options

command options, 328-31

printing options, 326

save options, 327

toolbar display options, 328

virus protection options, 328

windows options, 328

Options button, 80, 581

Options tab, 9

OptionsExtasCustom Lists, 581

Or operators, 114, 177, 178, 584, 586

ORDER BY field, 668

ORDER BY query, 664

Order Details table, 621-22, 624, 626, 634

Orders table, 621, 623-24, 625, 632

Organization Chart toolbars , 565

Orientation property, 58, 195, 711, 716, 729

Origin parameter, 290

OriginalValue property, 661, 668

Other parameter, 291

OtherChar parameter, 291

Outline object, 690-91, 836

OutlineLevel property, 691

Outlook mail client, 737-38

overlapping windows, 74

overwrite parameter, 276