Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

early binding, 677-679

Editor Format tab (VBE)

Code Colors option, 156

Font option, 156

Margin Indicator Bar option, 156

Size setting, 156

Editor tab (VBE)

Auto Data Tips option, 154

Auto Indent option, 154

Auto List Members option, 153

Auto Quick Info option, 154

Auto Syntax Check setting, 152

Default to Full Module View option, 155

Drag-and-Drop Text Editing option, 155

Procedure Separator option, 155

Require Variable Declaration option, 153

e-mail attachments from Excel, 690-693

e-mail (Outlook), sending messages, 687-690, 693-694

embedded charts

activating, 603

creating, 575-577

double-clicking, 603

events, 607-608

events, example, 608-610

printing on full page, 610-611

right-clicking, 603

/embedded switch, 75

emulating

MsgBox function, 506-510

SUM function, 301-304

End method, 320

End statement, 978

Engineering functions, category, 308

Enhanced Data Form

compared with Excel Data Form, 527-528

installation, 528-529

introduction, 526-527

entering code

copying, 152

macro recorder and, 148-152

manually, 145-148

EntryIsValid function, 650

Enum statement, 979

enumerations, type declaration, 979

Environ function, 983

EOF function, 983

Erase statement, 979

EraseRange function, InputBox method and, 393

Error Checking command, 31

error codes

ActiveX component can't create object, 991

Application-defined or object-defined error, 992

Argument not optional, 992

Automation error, 992

Automation object does not have a default value, 992

Bad DLL calling convention, 990

Bad file mode, 990

Bad filename or number, 990

Bad record length, 990

Bad record number, 990

Cannot call friend functionon object that is not an instance of defining class, 991

Can't create necessary temporary file, 991

Can't perform requested operation, 990

Can't rename with different drive, 990

Can't save file to TEMP, 992

Class doesn't support Automation or doesn't support expected interface, 991

Class not registered on local machine, 992

Code resource lock error, 992

Code resource not found, 992

Connection to type library or object library for remote process has been lost, 992

Device Input/Output (I/O) error, 990

Device unavailable, 990

Disk full, 990

Disk not ready, 990

Division by zero, 989

Error in loading DLL, 990

Expression too complex, 990

File already exists, 990

File already open , 990

File not found, 990

Filename or class name not found during Automation operation, 991

Get not supported at runtime, 991

Get not supported (write-only property), 991

Input past end of file, 990

Internal error, 990

Invalid Clipboard format, 992

Invalid file format, 991

Invalid format in resource file, 991

Invalid ordinal, 992

Invalid pattern string, 991

Invalid picture, 992

Invalid procedure call or argument, 989

Invalid property array index, 991

Invalid property value, 991

Invalid use of Null, 991

Key is already associated with an element of this collection, 992

For loop not initialized , 991

Method of data member not found, 992

Named argument not found, 992

Need property array index, 991

Object doesn't support current locale setting, 992

Object doesn't support named arguments, 992

Object doesn't support this action, 992

Object doesn't support this property or method, 991

Object or class does not support the set of events, 992

Object required, 991

Object variable or With block variable not set, 991

Out of memory, 989

Out of stack space, 990

Out of string space, 989

Overflow, 989

Path not found, 990

Path/File access error, 990

Permission denied , 990

Printer error, 992

Property not found, 991

Property or method not found, 991

Remote server machine doesn't exist or is unavailable, 992

Replacements too long, 992

Resume without error, 990

Return without GoSub, 989

Search text not found, 992

Set not permitted, 991

Set not supported at runtime, 991

Set not supported (read-only property), 991

Specified DLL function not found, 992

Sub or Function not defined, 990

Subscript out of range, 949, 989

This array is fixed or temporarily locked, 989

Too many Dynamic Link Library application clients , 990

Too many files, 990

Type mismatch, 989

User interrupt occurred, 990

Variable uses an Automation type not supported in Visual Basic, 992

Wrong number of arguments or invalid property assignment, 992

Error event, 661

Error function, 256, 983

Error in loading DLL, 990

error messages, returning, 983

Error statement, 979

error values, functions, 299-300

error-handling

examples, 258-260

procedures, 939

runtime errors, 255

syntax errors, 255

errors

error values, 60

formulas, 59-60

instructions, 980

simulating condition, 979

event handler procedures

arguments and, 635-637

code, entering, 634-635

introduction, 429-430

location, 631-632

UserForms, adding to, 435-436

writing for chart class, 608

Event statement, 979

events

AddIn object, 719-720

application events, 630, 656-660

application events, enabling, 657-658

chart events, 630, 654-655

class modules, 894-895

disabling, 632-634

embedded charts, 607-608

event sequences, 631

loops , preventing, 634

monitoring, 941

not associated with objects, 631

old version of Excel, 633

OnKey, 664-668

OnTime, 662-664

procedures, 250

types, 630

types, monitoring, 630-631

user-defined, declaring, 979

user-defined, firing, 980

UserForms, 437-439, 631, 661-662

UserForms, keyboard-initiated, 440-441

UserForms, mouse-initiated, 440

UserForms, SpinButton controls, 439-440

workbook events, 630, 637-643

worksheet events, 630, 645, 651-654

Excel

controlling from another application, 684-687

as database manager, 102

as data-entry tool, 102

developers, advantages for, 13-14

e-mail attachments from, 690-693

Excel 95, 11

Excel 97, 11

Excel 2000, 11

Excel 2002, 11

Excel 2003, 11

Excel 2007, 12

Excel 2007, new features, 19

as forms generator, 102

as games platform, 102

installed version, 128

logging usage, 848

MultiPlan, 8

as presentation device, 102

runtime version, 127

starting, 73-76

startup actions, 74

as text processor, 102

Version 2.1, 8

version 4, 10

version 5, 10

version 3 for Windows, 9

XLM macro language, 9

ExecuteMso method, 734

Exit Do statement, 979

Exit For statement, 979

Exit Function statement, 979

Exit Property statement, 979

Exit Sub statement, 979

Exp function, 983

exponents, 983

Export method, 895

Export procedure, 896-897

ExportARange procedure, 899

exporting

charts, 585-586

graphics, 586-587

objects, Project Explorer, 143-144

ranges to HTML file, 849-852

ranges to text files, 845-846

ranges to XML file, 852-855

ExportRange procedure, 845-846

ExportRange property, 895

ExportToHTML procedure, 849-851

ExportToXML procedure, 854

Expression too complex error, 990

extended file properties

album title, 839

artist, 839

attributes, 839

audio sample rate, 839

audio sample size, 839

author, 839

bit rate, 839

camera model, 839

category, 839

channels, 839

comments, 839

copyright, 839

date accessed, 839

date created, 839

date modified, 839

date picture taken, 839

dimensions, 839

duration, 839

genre , 839

name, 839

owner, 839

pages, 839

program description, 839

protected, 839

size, 839

status, 839

subject, 839

title, 839

track number, 839

type, 839

year, 839

external controls, UserForms, 480-482

external databases, 40

ExtractElement function, 369-371