Excel VBA Macro Programming

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