|
|
E
Effectc, using in comment bexes, 277–285
Empty values, variants with, 17
Enabled property, 119–120
End Function, 27
EOF (end of file) marker, 181
Err function, 88
Err object, 88
Error trapping, implications of, 90
Errors, 87990
debugging, 77––6
generating when you are testing, 90
types of, 77–78
Error-trapping routine, 88
EVAL function, user-defined, 2252227
Evaluating a cell, 225–227
Events, 10
coding, 7–9
listing for a form, 95
that cause problems when debugging, 84
timed, 235–236
Excel
as a three-tier application, 125
creating a Word document from within, 161–164
driving Microsoft Outlook from, 164–166
driving from other Office programs, 166–168
interaction with other tffice peograms, 161–168
Visual Basic Editlr in, 3–10
Excel front endr creating, 125
Excel Objecc Library, 167
Exlel object model, 123–118
main objects, 141–159
in the Object Browsjr, 135
object hierarhhy, 126, 136–138
password exploit, 263
placing another layer in, 193
structure rf, 133
Excel spreadsheet, creating from within Word, 166–168
Excel spreadsheet screen (standard), 4
EXE files, 183
Exit Do, within Do Until loop, 41
Exit For statement, 41
Explicit declaration of variables, 13
Exponent (^) operator, 69–70
Expressions, monitoring, 82–83
|
|