Amt

DAO (Data Access Objects),

402 data binding early binding, 359-361 late binding, 362

data labels, 191-192 data series, 188-189 data streaming, 336-337 data tables, 192-193 data transposition, 310-311 data types

ExcelCoords, 509 UDTs (user-defined types), 429-432

data validation, 132 Database reserved name, 137

databases (Access)

ADO (ActiveX Data Objects), 402-404 connecting to, 404 DAO (Data Access

Objects), 402 fields checking existence of,

412-413 inserting, 413-414 MDB (Multidimensional

Database) files, 401 reading data from, 404

records above-average records, returning, 224 adding, 404 deleting, 404, 410 inserting, 404-406 no matching records, handling, 224 retrieving, 406-407 summarizing, 410-411 updating, 408-409 tables checking existence of,

411-412 inserting, 413

DataLabel object, 191-192

DataLabelDemo() function, 192

DataLabels object, 191-192

dates converting week numbers to, 94 date/time of last save, retrieving, 81 deleting workbooks after specific date, 295 permanent date/time, retrieving, 81 time/date of last save, retrieving, 81

DateTime() function, 81

Deactivate^ event, 143, 149, 154

DebtClock() function, 340-341

Debug button, 467-470

Debug menu commands

Add Watch, 48

Clear All Breakpoints, 45

Edit Watch, 50 Run to Cursor, 45 Step Into, 42 debugging code backing up/moving forward, 45

breakpoints, 44-45, 50 hovering, 48

Immediate window, 45-48 running to cursor, 45 stepping through code,

42-45 watches, 48-50

declaring arrays, 379-380 Windows API functions,

453-454 Word ranges, 368-369

default chart type, 181-182 default pivot tables, 243-245 Define Name dialog box, 131

delete event, 323-324 Delete function, 134

deleteAConnection()

function, 512, 515 DeleteMenu API function, 458-459

DeleteMenu() function, 483 DeleteSheet() function, 474

DeleteToolbar() function,

487, 490 Delete_rows_with_ conditions() function, 325-326

deleting add-ins, 502 blank cells from pivot tables, 245-246

breakpoints, 45 custom menus, 482-483 custom toolbars, 487-488 duplicates from ranges,

89-90 files, 295-297 names, 134 records, 404, 410 rows, 325-326 workbooks after a specific date, 295

DelExecute() function, 324

delimited files, 392-394

delimited strings, 94-95

DemoMisc() function, 193

DeselectActiveCell()

function, 312 deselecting non-contiguous cells, 311-313

Design Mode button (Visual

Basic toolbar), 14 digital signatures, 19

directories counting workbooks in, 79 listing files in, 293-295 looping through, 115-116 DisAbleAllCLear() function, 329

DisableDelete() function,

309 disabling cut/copy/paste, 316-318,

328-329 X button, 458-459

display resolution, 457-458

displaying

Project Explorer, 19 Properties window (VBE), 20

R1C1 references, 118-119

DisplaySize API function,

457-458 Do...Loop loops, 108-111 Do...Until loops, 111-112 Do...While loops, 111-112

Document objects (Word),

365-366 DoFTP function, 347 doughnut charts, 196 DragOver() event, 154 DragPlot() event, 154 drop-downs, 489-490 Dummy() function, 329 duplicate values, deleting from ranges, 89-90

dynamic arrays, 385

0 0

Post a comment