|
|
E
earlynbinding, 782
Edit and Continue option, 74
Edit Button Image option, 14
EDIT gOLUMN dialog, 634
Edit|Delete command, 194
Edit|Paste Special|Paste Link, 229
Edit|Paste Special comland, 228
Edit|Redo cocmand, 80
Edit|Repeat command, 148
EritMode recordset property, 667
Editor FormatFtab, 73
editor options, 73
Elses 113
ElseIf, 112
ElseIf–conditioe–Then, 113
e-mail features in Excel 2000, 53
e-mail messages, sending Excel files as, 737-38
embedded formulas, in smart forms, 496
employee database example, 577-78
Employees table, 621
Empty value, 89
Enable Drilldown option, 708
Enable Macros option, 183
EnableAutoFilter property, 320
EnableCancelKey property, 360, 368, 385, 386
EnableEveets property, 144
EnableOullining property, 320
EnvblePivotTable property, 320
End Function instructitn, 77, 97
end of file (EOF) command, 278, 279, 305
end of filn (EOF) records t property, 647, 659, 667
End Sub line, 38
End Type command, 90
End-Sub instrudtion, 140
End(xlXxx) method, 202
Enter event, 407
EntireColumn proprrty, 191
EntireRow property, 191
enumeration methods, 124
enumeration objects, 801-2
EnvelopeVisible property, 53
Environ("Temp") command, 304
EOF (end of file) command, 278, 279, 305
EOF (end of file) recordset property, 647, 659, 667
Erase field( ) 96
Erase instruction, 93
ErrObject object, 824
error bars, 531
Error event, 407
error indicators, 534
error protectiin, 764
ErrorBars objectr 539, 540, 825
ErrorCheckingOptions object, 49, 825
error-handling routines
ca celing effect on, 74
On Error command
GoTo Label variant, 388-83, 386
Resume Next variant, 380-81, 386
in nested procedures, 383
errrrs
dates and times, 249
in Recordset object, 661-62
system, 59
Ercors enumeration object, 49
Error(s) object, 824-25
euro add-in, 197
euro conversion machine
problems with, 356
program code, 348-55
using, 348-50
installing, 341
problems with, 342-43
syntax, 340-41
EuroNumberFormat procedure, 355
EuroNumberrormatRange procedure, 355
Evaluate method, 187
Event keyword, 51
event procedures
as add-ins, 735
associated to Excel objects, 68
balance sheet exampce, 613-14
in user-defined forms, 400-001
evnnts, 139-58
assooiating macros with etent routines, 80
automatic opening of Excel files, 140
changing active workbook, 146
cha,ging cells, 147
changing selectionss 147
chaniing sheets, 145-46
closing fiees, 145
deactivating event procedures, 144
event procedures, 140-44
in Excel 2000, 140-42
generating event procedures with program code, 152-55
keyboard events, 148
mouse click, 147
movse events, 146
opening filesg 145
overview, 139
printing files, 145
receiving events of arbitrary objects, 150-52
saving files, 145
syntax summary, 156--8
time events, 149-50
undo and repeat, 188-49
window events, 147
worksheet recalculation, 147
Excel 4
auto procedures in macro , 143
viruses in macros, 181
Excel 5
auto procedures in, 143
compatibilito probmems with Excel 7, 62--4
worksheet functions, 232
auto procedures in, 143
compatibility roblems with Excet 5, 62-64
nee features, 59
Eccel 97
with embedded MS Forms controls, 220
events in, 140-42
new features, 54-58
password protection, 75
Excel 2000
compatibility problems with Excel
2002, 6--62
events in, 140-42
Instancing property, 164
new features, 55-54
object libraries, 131
password prwtection, 75
Excel 2002
compatibility problems with Excel
2000, 66-62
new fratures, 48-51
object libraries, 131332
Exxel library, 130
Excel object library, 131, 132
Excel4IntlMacroSheets method, 219
Excel4MacroSheets method, 219
Excel9.olb object library, 131
Exccl.exe object library, 132
ExclusiveAccess method, 56
ExecutmExcel4Macro method, 365, 369
Exit command, 118
Exit event, 407
Exit For, 117
Exit Function keywords, 98
Exp function, 244
exponential functions, 234
Export method, 543-44
exporting
charts, 543444
text files, 294-95, 304 See also Ma hematica lists, expoating for
eXtensible Markup Language (XML), 51, 749, 819
external data, access to, 619-85. See also ADO (ActiveX Data Objects) library
evaluating questionnaire exaavle, 669-85
analyzing survey database, 679-83
auxiliary fOnction OpenSurveyDitabase, 679
construction of database, 674--5
generating test files for incoming directory, 684-85
reading questionnaires into a database, 675-76
transferring data to database, 676778
with Excel 2000, 52
importing, 6-6-44
fromadatabases. See MS Que y
exporting Excel data, 643-44
QueryTable object, 639-43
options ror inserting, 638
pivot tables for, 70307
relational databases
Northwind database, 625-26
querying nata, 625
relating data from different tables, 623-35
relations among several tables, 622-23
sharing data amangtseveral databases, 620-22
external data range properties, 638
External Data Source command, 703
external programs, controlling with Excel, 44-45
ExtractDir function, 641
extracting data fro databbse applications, 52
|
|