Index_O


O

Object Browser, 134 ‚ 137
Object Browser shapes , 280
Object collections. See Collections
Object hierarchy, 126, 136 ‚ 138
Object instance, creating, 198
Object Libraries
ADO, 179
ADO Recordset, 179
Microsoft Excel, 167
Microsoft Office, 161
Microsoft Outlook, 165
Microsoft Word, 161 ‚ 162
Object methods , 126 ‚ 133
calling, 130 ‚ 133
explained, 128, 130
tip text for, 130
Object model. See Excel object model
Object properties. See Properties
Objects
creating, 193 ‚ 195
explained, 126
ODBC Data Source Administrator dialog, 177 ‚ 178
ODBC driver for a data source, 178
ODBC links, 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
On Error Resume Next statement, 90, 119, 214, 222, 283
On Error Resume statement, 89 ‚ 90
On Error routine, 247, 252
OnAction property, 118, 292, 298
OnTime method, 235 ‚ 236
LatestTime parameter, 236
Schedule parameter, 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, 70 ‚ 71
Is, 74 ‚ 75
Like, 75
logical, 71 ‚ 74
order of precedence of, 67
use of brackets with, 67
Option Explicit, 13
Optional arguments, 31
Optional (keyword), 31
Optional parameters, 130 ‚ 131
Optional properties, 135
OptionButton control, 101
Or operator, 36, 65, 72 ‚ 73
OrganizationName property (Application object), 145



Excel VBA Macro Programming
Excel VBA Macro Programming
ISBN: 0072231440
EAN: 2147483647
Year: 2004
Pages: 141

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net