Index_A

A

A1 notation, 192

Abs function, 234, 244

absolute recording, 16, 82

absolute value, 234

AbsolutePosition property, 660

Accelerator property, 35, 403

Access databases, 655

as ActiveX server program, 763-65

Import wizard, 644

access key, 403

ACCESSLINKS ADD-IN option, 643

account variables , 616

accountCell variable, 616

accountMonth variable, 608

accountNr variable, 616

accountWs variable, 616

ActionControl property, 476, 483

Activate event, 144, 145, 146, 157, 158, 436

Activate method, 187, 189, 216, 220, 540

Activate property, 217

activateEvents variable, 144

ActivateMicrosoftApp method, 788, 789

ActivateNext method, 217

ActivatePrevious method, 217

active cell , 186

active objects, 128

ActiveCell property, 128, 187-88

ActiveCell.Offset(2, 2).Range("A1") command, 16

ActiveChart property, 128, 219, 540

ActiveConnection command property, 668

ActiveDialog property, 219

ActiveMenuBar property, 128

ActivePane property, 128

ActivePrinter property, 128

ActiveSheet property, 125, 126, 128, 219

ActiveSheet.Names( ) method, 193

ActiveWindow property, 217

ActiveWindow.SelectedSheets.Count procedure, 299

ActiveWorkbook method, 215

ActiveWorkbook property, 126, 128

ActiveWorkbook. Name procedure, 303

ActiveWorkbook.Names( ) method, 193

ActiveWorkbook.Path property, 283, 303

ActiveX automation. See also Visual Basic .NET

ActiveX libraries, problems with, 781-82

controlling programs without, 786-88

defining new objects, methods , and properties for, 772-75

editing OLE objects with, 777-79

with Excel as client

Access report example, 763-65

creating connection to OLE program, 761-63

HTML display example, 766-67

with Excel as server, 767-72

limitations, 760, 780

overview, 759-60

ActiveX controls, 404-5

RefEdit, 432-34

as Web components , 741

ActiveX Data Objects. See ADO (ActiveX Data Objects) library

ActiveXxx properties, 128, 218

ActualSize field property, 668

Add command, 473

Add method, 98, 124, 126, 127, 160, 165, 167, 216, 220, 542

Add procedure, 98

Add Watch form, 377-79

AddComment method, 193

AddDiagram method, 565

add-ins, 111

applications of, 733

COM, 317-18, 339, 736

event procedures as, 735

invisibility of, 735-36

loading, 733-34

manager, 733-34

programming limitations, 735-36

properties of, 732

user -defined functions in, 309, 734-35

viruses in, 182-83

AddIns object, 804

AddinUninstall event, 157

AddItem, 64

AddLine, 563

AddNew method, 661, 677-78

Address method, 192

AddressLocal method, 192

AddShape, 563

Adjustments object, 804

adLockBatchOptimistic LockType setting, 655, 656

adLockOptimistic LockType setting, 655, 656

adLockPessimistic LockType setting, 655

adLockReadOnly LockType setting, 655

adModeRead setting, 651

adModeShareDenyNone default setting, 651

adModeShareExclusive setting, 651

ADO (ActiveX Data Objects), 645, 799

ADO (ActiveX Data Objects) library, 52, 571, 572, 574, 645-68

2.1 object library, 131, 132

connections, 650-53

vs. DAO library, 646

Recordset object, 654-62

adding data records, 661

data fields, 657-59

deleting records, 661

editing existing records, 660-61

navigation in data records, 659

positional information, 660

possible errors, 661-62

Recordset types, 655-57

searching and locally sorting data records, 660

SQL abbreviations, 655

SQL commands, 662-66

syntax summary, 666-68

ADOMD (ADO multidimensional) library, 707

adOpenDynamic, CursorType setting, 656

adOpenForwardOnly, CursorType setting, 656

adOpenKeyset, CursorType setting, 656

adOpenStatic, CursorType setting, 656

adPosBOF ( ˆ’ 2) value, 660

adPosEOF ( ˆ’ 3) value, 660

adPosUnknown ( ˆ’ 1) value, 660

adUseClient, CursorLocation setting, 656-57

adUseServer, CursorLocation setting, 656-57

Advanced button, 287

advanced filters, 585-88

AdvancedFilter function, 590

advantages of Excel, 574

after parameter, 589

age calculation, 255-56

AITest function, 734-35

Alias keyword, 756

aligning charts , 542

(All) setting, 583

AllowEditRange object, 49, 323, 804-5

Alt+Backspace combination, 84

Alt+Backspace key combination, 80

Alt+F11 key combination, 11, 69, 76, 84

Alt+F6 key combination, 84

Alt+W key combination, 23

altering data, with Database form, 579-80

AltStartupPath property, 284

ampersand (&), 35, 177, 238

AnalyseCommandBars procedure, 476-77

Analysis\Atpvbaen.xla file, 132

AnalyzeDatabase procedure, 679, 683

analyzedata.xls file, 670

AND operator, 114, 177, 178, 584, 586

API (Application Programming Interface) functions, 754

apostrophe ( ' ), 78

app variable, 152

app_NewWorkbook, 152

AppActivate command, 787, 789

AppClass class module, 481

Application class, 50

application events, 156-57

Application object, 52, 123, 125, 126, 144, 151, 152, 215

CalculationState property, 360-61

as default object, 802

DisplayAlerts property, 360

general options, 329

as highest in hierarchy, 794

Interactive property, 360

methods and properties in general, 805

Ready property, 361

ScreenUpdating property, 356-57

StatusBar property, 358-59

in Watches window, 379

Application Programming Interface (API) functions, 754

Application.ActiveWorkbook object, 126

ApplicationAltStartupPath property, 284

Application.AltStartupPath property, 303

Application.DefaultFilePath property, 283, 303

Application.FileDialog, 285

Application.GetOpenFilename procedure, 303

Application.GetSaveAsFilename procedure, 303

Application.InputBox method, 241, 393-95

Application.LibraryPath property, 284, 303

Application.Name( ) method, 232

Application.Path property, 283, 303

Application.Pi constant, 91

Application.ReferenceStyle property, 201

applications, freestanding

extending standard menu, 486-89

hiding and unhiding custom toolbars , 489-90

operating mechanisms, 485

using custom standard menu, 490-92

Application.StartupPath property, 303

Application.TemplatesPath property, 303

Application.UserLibraryPath property, 303

Application.Volatile instruction, 313

Application.WorksheetFunction.Ceiling function, 233

Application.WorksheetFunction.Days360

function, 251

Application.WorksheetFunction.Even function, 233

Application.WorksheetFunction.Floor function, 233

Application.WorksheetFunction.Odd function, 233

Application.WorksheetFunction.Round function, 233

Application.WorksheetFunction.RoundD own function, 233

Application.WorksheetFunction.RoundU p function, 233

ApplyCustom-Type method, 543

ApplyDataLabels method, 820

Apress Web site, 9

archive directory, 670, 678

Areas method, 190-91, 206

Areas object, 806

arithmetic operators, 175, 177

Arrange method, 390

Array command, 94

Array construct, 602

array_macro1 procedure, 100

array_macro2 procedure, 100

array_macro4 procedure, 101, 102

arraytest procedure, 101

arraytest_continue program unit, 101

arraytest_error program unit, 101

article data type, 91

Articles property, 172

As constant, 92

Asc function, 242, 246

ASCII files, 54

AscW function, 246

Ask Again Later button, 37

Assign Macro option, 13

asterisk (*) operator, 177

AtEndOfLine method, 276

AtEndOfLine property, 303

AtEndOfStream method, 276

AtEndOfStream property, 303

Atn function, 244

Atpvbaen.xla file, 132

Attributes property, 176, 272, 302, 668

Author property, 171

Auto Data Tips option, 73

Auto List Members option, 73

auto macros, 184

auto procedures, 143, 156

Auto Quick Info option, 73

Auto Syntax Check option, 9, 73

Auto_Open procedure, 140, 179, 184

AutoCorrect object, 806

AutoFill method, 363

AutoFilter function, 590

AutoFilter object, 806

Autofilter on/off button, 578

autofilters, 583-85

AutoForm object, 855

autoformat chart types, 529-30

AutoFormat method, 543

automated data presentation, macros for, 42

automatic backups , 49

automatic data reporting, 544-58

overview, 544

program code, 547-58

Chart.xls components, 547-48

daily reports , 550-53

menu management, 556-58

monthly reports, 553-56

test data, 545-47

automatic saves, 80

AutoOutline function, 691

AutoRecover object, 49, 806

AutoShapes objects, 57

AutoShapeType property, 561

AvailableSpace property, 302

Average function, 635, 695

AverageProduct function, 315-16

AVG(age) command, 679

Axes object, 536

Axis object, 539, 807

AxisTitle object, 807