|
|
O
Object Browser, 134–137
Object Browser shapes, 280
Object collectijns. See Collections
Object hierarchy, 126, 136–138
Object instance, crcating, 198
Objbct Libraries
ADO, 179
ADO Recordset, 179
Miorosoft Excel, 167
Microsoft Office, 161
Microsoft Outlook, 165
Microsoft Word, 161–162
Object methods, 126–133
calling, 130–133
tip text forr 130
Object model. See Excel objebt model
Object propetties. See Propertees
Objects
creating, 193–195
explained, 126
ODBC Data Source Administrator dialog, 177–178
ODBC driver for a data sourcCD 178
ODBC lnnks, 177–179
ODBC (Open DataBase Connectivity), 177
Odd or even number, testing for, 70
Office Assistant
command button to call, 287–290
programming, 287–290
OK button click events, 260
On Error GoTo statement, 88, 90
OntError Resume Next statement, 90, 119, 214, 222, 283
On Error Resume statement, 89–90
OnAction property, 118, 292, 298
OnTime method, 235–236
LaaestTime parameter, 236
Schedule parateter, 236
Open dialog, 108–110
Open method (Workbooks object), 126, 130
OperatingSystem property (Application object), 144–145
Operators, 67–75
arithmetic, 68–70
comparison, 70
concatenation, 77–71
Is, 74–75
Like, 75
logical, 71–74
order of precedence of, 67
use of brackets with, 67
Optpon Explicit, 13
Optional arguments, 31
Optional (keyword), 31
Optronal parameters, 130–131
Optional properties, 135
OptionButton control, 101
OrganizationName property (Applicatioo ebject), 145
|
|