Index_O

 < Day Day Up > 



O

Object box in Code window, 43

Object Browser, 326

listing dialog box constants, 389

locating events, 277

Object Browser window, 44, 45

object collections, 79

object levels in a chart, 326

object model, 107, 108

object references, characterizing as properties, 300

object variables, 301

creating, 455

creating charts as, 323

declaring, 72

defining, 72

objects with multiple, 303

referring to applications, 451

setting to uninitialized state, 302

Object_Change event procedure, 265

object-oriented programming, 25-28

objects, 26, 42, 299

accessing, 301

actions performed by, 119

adding to a collection class, 314

adjusting vertical spacing among, 46

aspects of, 26-28

automating, 465

centering on a form, 46

containing, 107

creating, 300, 301

declaring, 302

deleting all in a collection, 315

destroying, 302, 311

exposing common directly, 108

formatting, 219-37

grouping selected, 46

instantiating, 301

interface to, 304

lining up along a common border, 46

monitoring the state of, 300

with multiple object variables, 303

naming, 43

Nothing value and, 302

as nouns, 300

removing groupings, 46

representing a collection of similar things, 300

resizing, 46

supported by particular events, 277

used to control Excel, 107

validating information in, 317

working with, 107

Objects folder, 42

Object_SelectionChange event procedure, 265

ObjectVariable Is Not Nothing expression, 302

ODBC

connection string, 352

data provider for, 486

Office applications, 445

add-ins spanning multiple, 259

interacting with, 455-60

Office Clipboard, 20

Office documents, publishing to the Web, 535

Office Marketplace, 8

Office Object Model, 281

Office objects, 457

Office Web Components. See Web Components

Offset property, 167-69

OK button, 68

OLAP database, 347, 348

OLAP property of PivotCache object, 353

OLAP server, 347

OLE Automation. See Automation

OLE DB call, translating, 486

OLE DB connection string, 352

OLE DB data type, 494

OLE DB protocol, 481

On Error command, 82

On Error Resume Next statement, 314, 380, 513

On Error statement, 360

OnAction event, testing, 379

OnAction property, 374, 375

OnAction routine, 400

OnAddInsUpdate method, 248, 249

OnBeginShutdown method of IDTExtensibility2 interface, 248, 249

OnBeginShutdown routine, 261

OnConnection method, 252

of IDTExtensibility2 interface, 248

passing the application object to, 259

OnConnection routine, 260

OnDisconnection method, 249, 252

OnKey method, 125-27

OnLine Analytical Processing server, 347

OnStartupComplete method, 249

OnStartupComplete routine, 260

Open dialog box, 120, 291

Open event, 268, 269, 433

open files, checking for, 134

Open method

of Application object, 295

of Connection object, 484

of Documents collection, 458

opening a connection to a database, 513

opening existing Web pages, 528

of Recordset object, 492, 514

of Workbooks collection, 130-31

Open statement of VBA, 295

OpenText method of Workbooks, 132-34

OpenWriteExcelWbkContents procedure, 463

operating system

for a text file, 133

for a workbook, 130

Operator property, 188

Option Base statement, 64

Option Explicit statement, 254

Option Private Module statement, 91

Option Private statement, 86, 99

optional parameters, not allowed in events, 310

OptionButton controls, 409, 431

Options dialog box, 50-52

Color tab, 224, 226

Custom tab, 224

displaying, 48

options for a wizard, 438-40

Or operator, 473

Oracle databases, connecting to, 486

Order By clause, 475, 493

Order item on the Format menu, 46

Organize Supporting Files in a Folder check box, 522

Orientation property

of PageSetup object, 154

of PivotField object, 353, 355

of ScrollBar control, 411

Origin parameter

of Open method, 130

of OpenText method, 133

OriginalValue property, 494

Other parameter, 134

OtherChar parameter, 134

outline format, specifying, 355

Outlook, adding a reference to, 452

Outlook Calendar, 450, 452

Outlook Contacts folder, 453

Outlook Object Library, 452

out-of-process components, 248

output parameter to a stored procedure, 490

OverWrite alert, 116



 < Day Day Up > 



Microsoft Excel 2003 Programming Inside Out
Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
ISBN: 0735619859
EAN: 2147483647
Year: 2006
Pages: 161

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