Index_E

E

early binding, 782

Edit and Continue option, 74

Edit Button Image option, 14

EDIT COLUMN dialog, 634

EditDelete command, 194

EditFind command, 582, 589

EditPaste SpecialPaste Link, 229

EditPaste Special command, 228

EditRedo command, 80

EditRepeat command, 148

EditUndo command, 80, 148

EditUndo function, 579, 582

EditMode recordset property, 667

Editor Format tab, 73

editor options, 73

Else, 113

ElseIf, 112

ElseIfconditionThen, 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

EnableEvents property, 144

EnableOutlining property, 320

EnablePivotTable property, 320

End Function instruction, 77, 97

end of file (EOF) command, 278, 279, 305

end of file (EOF) recordset property, 647, 659, 667

End Sub instruction, 77, 86

End Sub line, 38

End Type command, 90

End-Sub instruction, 140

End(xlXxx) method, 202

Enter event, 407

EntireColumn property, 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

Eqv operators, 114, 178

Erase field(), 96

Erase instruction, 93

Err function, 384, 386

ErrObject object, 824

error bars, 531

error checking, 311, 525

Error() command, 384, 386

Error event, 407

error indicators, 534

error messages, 73, 649

error protection, 764

error trapping, 372, 373, 374

ErrorBars object, 539, 540, 825

ErrorCheckingOptions object, 49, 825

error-handling routines

canceling effect on, 74

On Error command

GoTo Label variant, 381-83, 386

GoTo variant, 383, 386

Resume Next variant, 380-81, 386

in nested procedures, 383

errors

dates and times, 249

in Recordset object, 661-62

system, 59

Errors enumeration object, 49

Error(s) object, 824-25

Esc key, 20, 35, 84

euro add-in, 197

euro conversion machine

problems with, 356

program code, 348-55

using, 348-50

euro symbol, 54, 239

EuroConvert function, 54, 239

installing, 341

problems with, 342-43

syntax, 340-41

EuroNumberFormat procedure, 355

EuroNumberFormatRange procedure, 355

Evaluate method, 187

Event keyword, 51

event procedures

as add-ins, 735

associated to Excel objects, 68

balance sheet example, 613-14

in user -defined forms, 400-401

events, 139-58

associating macros with event routines, 80

automatic opening of Excel files, 140

changing active workbook, 146

changing cells , 147

changing selections, 147

changing sheets, 145-46

closing files, 145

deactivating event procedures, 144

event procedures, 140-44

in Excel 5, 142-43, 158

in Excel 7, 142-43, 158

in Excel 97, 55, 140-42

in Excel 2000, 140-42

generating event procedures with program code, 152-55

keyboard events, 148

mouse click, 147

mouse events, 146

opening files, 145

overview, 139

printing files, 145

receiving events of arbitrary objects, 150-52

saving files, 145

syntax summary, 156-58

time events, 149-50

undo and repeat, 148-49

window events, 147

worksheet recalculation, 147

Excel 4

auto procedures in macros, 143

viruses in macros, 181

Excel 5

auto procedures in, 143

compatibility problems with Excel 7, 62-64

events in, 142-43, 158

worksheet functions, 232

Excel 7, 232

auto procedures in, 143

compatibility problems with Excel 5, 62-64

events in, 142-43, 158

new features, 59

Excel 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, 61-62

events in, 140-42

Instancing property, 164

new features, 51-54

object libraries, 131

password protection, 75

Excel 2002

compatibility problems with Excel

2000, 61-62

new features, 48-51

object libraries, 131-32

Excel library, 130

Excel object library, 131, 132

Excel4IntlMacroSheets method, 219

Excel4MacroSheets method, 219

Excel9.olb object library, 131

Excel.exe object library, 132

ExclusiveAccess method, 56

Execute method, 666, 668

ExecuteExcel4Macro method, 365, 369

Exit command, 118

Exit event, 407

Exit For, 117

Exit Function keywords, 98

Exit Sub instruction, 98, 357

Exp function, 244

exponential functions, 234

Export method, 543-44

exporting

charts , 543-44

to HTML, 740-41, 743-44

text files, 294-95, 304 See also Mathematica lists, exporting for

eXtensible Markup Language (XML), 51, 749, 819

external data, access to, 619-85. See also ADO (ActiveX Data Objects) library

evaluating questionnaire example, 669-85

analyzing survey database, 679-83

auxiliary function OpenSurveyDatabase, 679

construction of database, 674-75

generating test files for incoming directory, 684-85

reading questionnaires into a database, 675-76

transferring data to database, 676-78

with Excel 2000, 52

importing, 626-44

from databases. See MS Query

exporting Excel data, 643-44

QueryTable object, 639-43

options for inserting, 638

pivot tables for, 703-7

relational databases

Northwind database, 625-26

querying data, 625

relating data from different tables, 623-25

relations among several tables, 622-23

sharing data among several 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 from database applications, 52