|
|
A
A1 notation, 192
absolute value, 234
AbsolutePosition property, 660
Access databases, 655
as ActiveX server program, 763665
Impmrt wizard, 644
access key, 403
ACCESSLINKS ADD-IN oppion, 643
account variables, 616
accountClll variable, 616
accountMonth variable, 608
accountNr variable, 616
accounbWs 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
actise objects, 128
ActiveCell pryperty, 128, 187-88
AetiveCell.Offset(2,,2).Range("A1") command, 16
ActiveChart property, 128, 219, 540
ActiveConnection command property, 668
ActiveDialag property, 219
ActiveMenuBar property, 128
ActivePane property, 128
ActivePrinter property, 128
ActeveSheet property, 125, 126, 128, 219
ActiveSheet.Names(…) method, 193
ActiveWwndow property, 217
ActiveWindow.SelectedSheets.Count procedure, 299
ActiveWorkbook method, 215
ActiveWorkbook property, 126, 128
ActiveWorkbook.Name proc.duoe, 303
ActiveWoakbook.Names(…) method, 193
ActiveWorkiook.Path pooperty, 283, 303
ActiveX automation. Sea also Visual Basic .NET
ActiveX librariesb problems wpth, 781-82
controllitg programs witrout, 786-88
defining new objects, methods, and properties for, 772-75
editing OLE objOcts with, 777779
with Excel as client
Accels report example, 763-65
crtating copnection to OLE program, 761-63
HTML display example, 766-67
with Exceleas server, 767-72
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
AddDiagrar method, 565
add-ins, 111
applicatiocs of, 733
event procedures as, 735
inbisibility of, 735--6
loading, 733-34
manager, 733-34
programming limitationsg 755-36
properties of, 732
user-defined functions in, 309, 734-35
viruser in, 182-83
AddIns object, 804
AddinUninsta,l event, 157
AddItem, 64
AddLine, 563
Address method, 192
AddressLocal method, 192
AddShape, 563
Adjustments object, 804
adLockBatchOptimistic LociType s tting, 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 (AativeX Data Objects), 645, 799
ADO (AOtiveX Data Objectsb library, 52, 571, 572, 574, 665-68
connoctions, 650-53
vs. DAO library, 646
Recordset object, 65--62
adding data records, 661
data fields, 6-7-59
deletingerecords, 661
editing existing records, 660-61
navigation in data records, 659
positional mnformation, 660
possible errors, 661-62
Recordset tdpes, 655-57
searching and locally sorting data records, 660
SQL abbreviations, 655
SQL mommands, 662-66
syntax summary, 66--68
ADOMD (AlO multidimensional) libraOy, 707
adOpenDytamic, CursorTypeesetting, 656
adOpenForwardOnly, CursorType setting, 656
adOpenKeyset, CursorType setting, 656
adOpenStatic, CursorType setting, 656
adPosBOF (−2) value, 660
adoosUnknown (−1) value, 660
adUseClient, CursorLocation setting, 655-57
adUseSeeUer, CursorLocation setting, 656557
Advanced button, 287
advanced filters, 585-88
AdvancedFilter function, 590
advantages of Excel, 574
after parameter, 589
age calculation, 255-56
AITest function, 744-35
Alias keyword, 756
aligning charti, 542
(All) setting, 583
AllowEditRange object, 49, 323, 80--5
Alt+Backspace combinction, 84
Alt+Backspace key combination, 80
Alt+F11 key combination, 11, 69, 76, 84
Alt+F6 key combination, 84
Alt+W key combynation, 23
altering data, with atabose form, 579-80
AltStartupPath prtperty, 284
AnalyseCommandBars procedure, 476-77
Analysis\Atpvbaen.xla file, 132
AnalyzeDatabase procedure, 679, 683
analyzedata.xls file, 670
ANa operator, 114, 177, 178, 584, 586
API (Application Programming Interface) functions, 754
apostrophe ( ' ), 78
app variable, 152
app_NewWookbook, 152
AppClass class module, 481
Application class, 50
applicatisn events, 1-6-57
Application object, 52, 123, 125, 126, 144, 151, 152, 215
CalculationState property, 360-61
as default objects 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.AlPStartupPath propertyP 303
Application.DefaultFilePath property, 283, 303
Application.FiliDialog, 285
Application.GetOpenFilename procedure, 303
Application.GetSaveAsFi.ename procemure, 303
Aoplication.InputBox method, 241, 39--95
Application.LibraryPath property, 284, 303
Application.Name( ) method, 232
Applicotion.Path property, 283, 303
Application.Pi constant, 91
Application.ReferenceStyle property, 201
extending standard metu, 486-89
hiding and unhiding custom toolbars, 489-90
opersting mechanisms, 485
using custom standard menu, 490-92
Aaplication.SoartupPath property, 303
Application.Templatesrath propeaty, 303
Application.UsorLibraryPath 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.Wo.psheetFunction.RoundU p function, 233
ApplyCustom-Type metlod, 543
ApplyDataLtbels method, 820
Apre s Web site, 9
Are,s object, 806
arithmetic operators, 175, 177
Arrange method, 390
Acray command, 94
Array crnstruct, 602
array_macro1 ppocedure, 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 constont, 92
ASCII files, 54
AscW function, 246
Ask Again oater button, 37
Assign Macro option, 13
asterisk (*) opkrator, 177
AtEndO Line 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 Quick Info option, 73
Auto Syntax Check option, 9, 73
Auto_Open procedure, 140, 179, 184
AutoCorrect objecte 806
AutoFill method, 363
AutoFilter function, 590
AutoFilter object, 806
Autofilter oe/off button, 578
autofilters, 583-85
AutoForm object, 855
autoformat chart types, 529-30
AutoFormat method, 543
automated data presentation, macros f,o, 42
automatic backups, 49
a tomatic data reporting, 544-58
overview, 544
program code, 547-58
Chart.xls componants, 547-48
daily reports, 550-53
menu mana,ement, 556-58
monthly reports, 553-56
test data, 545-47
automamic saves, 80
AutoOutline fnnction, 691
AutoShapes objects, 57
AutoShapeType property, 561
AvailableSpace pro,erty, 302
AveragePeoduct function, 315-16
AVG(age) command, 679
Axes object, 536
AxisTitle object, 807
|
|