Index_D

 < Day Day Up > 



D

DAO (Data Access Objects), 481

data

in a collection class, 316

copying, 185-87, 422-24, 427-28

displaying graphically, 321

managing large volumes, 347

manipulating, 193-217

from multiple perspectives, 341

validating, 429-30

data area

in PivotChart, 346

in PivotTable, 358

Data Consumer, 481

data entry, 187-89

data fields

adding to PivotTables, 350

defining for PivotTables, 358

data files

creating XML, 549-50

importing into an XML schema, 552

data form, 540

data labels. See labels

data lists, 539-41

creating, 540

creating programmatically, 541-46

data map, 550, 551

Data Provider/Data Consumer model, 481

data providers for Access, 485

data series, modifying a chart's, 331

Data Series object, 322

Data Source keyword, 485

data sources

for Excel VBA, 481

for a ListObject object, 542

using the Internet as, 527-32

data types

associated with parameters, 490

available for validation, 188

conversion functions for, 61

creating custom, 72

defining, 58-59

for elements, 548

in relational databases, 468

returned by a Function procedure, 99

data validation code, 82

database client, 470

database info, saving, 504

database keys, 469. See also keys

database management systems, connecting to, 485-86

Database Properties dialog box, 501

Database Properties window, 516

database providers, changing, 503

database queries. See queries

database server, 470

database tables. See tables

databases

accessing from Excel, 470

comparing to spreadsheets, 467-70

connecting to, 501-5

designing and administering, 469

fundamental concepts, 467-69

manipulating with SQL, 471

retrieving rows from, 513

using with Excel, 467

databases administrator, 469

DataBodyRange property, 541

DataFields property, 350, 354

Data_Form reserved name, 182

DataRange property

of PivotField object, 354

of PivotItem object, 356

DataType parameter, 133

DataType property, 354

date and time functions, 213-16

Date arguments of DateDiff function, 216

Date data type, 60

Date format, default, 214

Date function, 214

date serial numbers, 213

Date variables, 60

DateAdd function, 214, 215

DateDiff function, 215

dates

difference between two, 215

handling, 60

manipulating, 213-17

prior to January 1, 1900, 213

DateSerial function, 214, 215

Date/Time data type, 61

DateValue function, 214

Day function, 214

days, number between events, 213

DB2 databases, 486

DBInfo user form, 498

initializing, 502-3

opening, 500

DblClick event, 402, 404

DBPath value, 510-11

DBQuery user form, 498

loading, 505

opening, 500

DBType variable, 510

DBWindowsAuth value, 511

Deactivate event

with user form, 400

for workbook, 269, 271

Debug menu, 46-47

debugging, 34

converting to, 61

the execution of procedures, 46

with hidden application objects, 458

macros, 34-36

Decimal data type, 58

DecimalSeparator parameter, 134

DecimalSeparator property, 529

decisions, made by applications, 74-77

declarations, avoiding errors through, 50

declarations section

declaring module variables in, 63

displaying for a code module, 92

entering using the keyboard, 93

default buttons in a message box, 69

default Date format, 214

default docked location, 49

Default to Full Module View, 51

Default Web Site Properties dialog box, 533

Define Name dialog, 182

Define Names dialog box, 17

Definition item on the View menu, 44

Delay property of SpinButton control, 407

Delete key, 127

Delete method

of a button, 261

of Charts collection, 152

of CommandBar object, 367

of CommandBarControl object, 374, 375

deleting a command bar, 371

invoking, 152

of ListObject object, 542

of Parameters collection, 489

of Recordset object, 491, 494

removing the entire command bar, 501

of Series object, 340

of Sheets collection, 152-53

of Validation object, 189

of Worksheets collection, 152

of XmlMap object, 554

Delete statement, 471, 479

DeleteCommandBar routine, 500

DeleteMenu procedure, 273

Delimiter parameter, 131

delimiters

for cells, 132

defining non-standard, 134

other than commas, 132

treating consecutive, 133

Desc (descending) keyword, 476

Description property

of Err object, 83

of Error object, 487

Description subkey for COM add-in, 250

descriptive names, 55

Deselect method, 330

Design mode, toggling, 48

Design Mode item on Run menu, 48

DetermineAllInterest procedure, 210

DetermineInterest procedure, 209

dialog boxes

customizing, 383-94

displaying existing, 384-88

documentation for, 386

formatting cells, 391

inserting or modifying charts, 391

modifying default settings in, 393

modifying existing, 388-94

passing arguments to existing, 393

setting default choices within, 388

Dialog object, 384

dialog sheets, 13

dialog types, 293

Dialogs collection, 384, 385, 389-93

Dialogs property, 393

dictionaries, 20

dictionary words, avoiding for passwords, 144

digital certificates, 38, 39

digital signatures, 37, 39

Digital Signatures dialog box, 48

digits, number visible in a cell, 175

Dim New statement, 301

Dim (dimension) statement

declaring objects, 302

declaring strings, 60

declaring variables, 58

Dir function, 282

Direction property of Parameter object, 490

directory organization for a computer, 287

dirty user forms, 427

Disable Macros, 37

DisableCustomize property, 366

DisableSave routine

in GetData routine, 424

in PutData routine, 428

DisableSave subroutine, 427

DiscountedPrice function, 255

DiscountPrice function, 250

DisplayAlerts property, 116, 152

DisplayDrawingObjects method, 139

DisplayErrorString property, 350

DisplayNullString property, 350

DisplayOutlookContactNamesEarly Binding procedure, 453

DisplayPalette procedure, 223, 225

DisplayRightToLeft property, 541

#DIV/0! error value, 124

divide by zero error, 50

DLL components, 248

DLL file, creating, 254

Do Until...Loop, 79-80

Do While...Loop, 79-80

dockable windows, specifying, 52

docked location for windows, 49

Document object, 457

Document Recovery task pane, 20

Document Updates task pane, 20

document workspaces, 6

documents, Word, 457-62

Do...Loop Until loop, 80-81

Do...Loop While loop, 80-81

DOS window, starting Windows- based applications from, 446

dot notation

calling methods, 27

placing the name of a module, 94

referring to properties in VBA, 26

with Select statement, 477

dots in a pixel, 220

Double data type, 59, 61

double quotation marks, 60, 473

Down Arrow key, 127

Drag-and-Drop-Text option, 51

DragToColumn property, 355

DragToData property, 355

DragToHide property, 355

DragToPage property, 355

DragToRow property, 355

drawing objects, 139

DrawingObjects parameter, 157

DropButtonStyle property, 414

drop-down button, hiding, 414

drop-down lists, 379

DropDownLines property, 378

DSTDEV function, 4

DSTDEVP function, 4

duplicate colors in color palettes, 225

DVAR function, 4

DVARP function, 4

dynamic arrays, 66



 < Day Day Up > 



Microsoft Excel 2003 Programming Inside Out
Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
ISBN: 0735619859
EAN: 2147483647
Year: 2006
Pages: 161

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net