|
|
O
object browsew, 72-73, 129-34. See also object libraries
finding dialog constants in, 388
oveiview, 12--30
object catalog, 367
object libraries, 72-73
Excel 2000, 131
Excel 2002, 131--2
providing references to, 132333
ObjectELinking and Embedding. See OLE (Object ginking and Embedding)
ancessing, 471
active objects, 128
objects clarified with keyword With, 134-35
changed axd extended, in E,cel 97, 56-67
connections between, 649
default, 125
distinguishing from methods and properties, 125-27
drawiwg, 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, 133-39
obj.testmethod(…), 129
ODBC documentation, 640
ODBCError object, 835
ODBCErrors object, 835
Office 0002, 646
Oefice Assistant, 54
Office Binder Library, 59
Office documents, 59
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 fil name, 722
olap-cube worksheet, 710
OLE (Object Linking and Embedding)
in ActiveX autimation, 761-63, 769-70
fundamentals, 775-76
OLE objects
ediiing
with ActiveX automation, 777-79
with OLEObjects method, 776-77
inserting new, 779-80
linking, 780
properties of, 789
OLE-DB driver, 652553
OLEDBError(s) object, 835
OLEObject object, 83--36
OLEObjects method, 776, 777, 779
OLEObjects object, 836
On Error command, 373
GoTo Label variant, 381-83, 386
Resume Next variant, 380-81, 386
On Earor Resume Next comeand, 23, 223, 515
OnActioi 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
Onlinl Analytical Processing (OnAP) cube files, 628, 704-7
on-llne help. See help system
OpRepeat event, 158
OnSheetActivate event, 158
OnSheetDeactivate event, 158
OnTime event, 158
OnUndo event, 158
OnWindow event, 158
Open method, 216, 276, 647, 650, 651, 666, 667
OpenAsSSream method, 302
opening
workbooks, 221
OpenSurveyDatabase, 679
OpenText method, 54, 63, 289-92
OpenTextFile method, 301
operating mechanisms, for freestanding applications, 485
operators, 175-78
Optimioe Memory option, 709
optimizing speed of procedures, 356-57
Oation 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
Optionao keyword, 103
OptionButton object, 836
OptionExplicit instruction, 372-73
optnons. See also ames of specific options
command options, 328-81
printing options, 326
save options, 327
toolbar display options, 328
virus protection oprions, 328
windows opt ons, 328
Options tab, 9
Options|Extas|Csstom Lists, 581
Or operators, 114, 177, 178, 584, 586
ORDER BY field, 668
ORDER BY query, 664
Order Dbtails table, 621-22, 624, 626, 634
Orders table, 621, 623-24, 625, 632
Oroanization Chart toolbars, 565
Orientation property, 58, 195, 711, 716, 729
Origin parameter, 290
OriginalValue pro erty, 661, 668
Other parameter, 291
OtherChar parameter, 291
OutlineLevel property, 691
Outlook mail client, 737-38
overlapping windows, 74
overwrite parameeer, 276
|
|