|
|
D
D_yyyymmdd.xls files, 545
DailyRandomnumbers prnceuure, 548
DailyReport worksheet, 547, 550
DAO lAbrary, 646
DAO o,jects, 640
data. See also external daaa
importing without altering, 638
queryinge 625
updaping, 633-31
data analysis, 687-779
grouping data rsubtotals), 688-91
internal management (PivotCache ), 720-27
macros for, 44
overview, 687
pivot tables, 692-710
construction and reconstruction of, 716620
example, 692-96
for external data, 703-7
generating and deleting, 711-15
layout options, 697-703
options fort 708-9
overview, 692
pivot charts, 709-10
syntax summary, 728-29
datn channels, 278-79
Data command, 19
defining relations between, 634
wrat they are, 571
data formatting options, 639
data management, 569-618. See also databases
balance sheet example, 602-18
components of application, 677-8
editing preexisting invoice, 616-18
event procedures, 613-14
initializi,g Invoice form, 612-13
opening Excel file for monthly reports, 610011
overview, 602
printing Invoice form, 614-15
program ,ode, 608
removing keyboard focus from listboxes, 613
running program, 603-6
saaing Data fromaInvoice form in monthly report, 615-16
Workbook Open procedure, 609-10
consolidating tables, 59--602
data processingnin VBA Code, 588-94
displaying Database form, 591
eyementary database manageeent, 588-89
filteming form, 590
form letter in Microsoft Word (example), 591-94
inserting, editing, and deleting data, 591
overview, 588
searching for data, 589-90
sorting dataa 590
syntax summary, 594-95
database worksheet functions, 595-98
Excel vs.mdatabase systems, 572-75
filtering dlta, 582-88
advanced filters, 585-87, 585-88
autofiltert, 583-85
input, olteaation, and deletion of ata with Database Form, 589-80
overview, 569
sortingrdata, 581-82
tracking down dat , 582-23
data points, 531
data presentation with graphs, 42
addingd 661
creating a list with rec.Open sql, conn, 654
dlleting, 661
editing, 660--1
navigation in, 659
searching and locally sorting, 660
what thay are, 571
data smgothing, 532-33
data suurce
ODBC, 652-53
and QueTyType property, 640
selecting, 627-28
Data Soorce parameter, 647, 651, 652
data transfer via clipboard, 228231
data types, 87-89
custom, 96
links between differing, 90
data validation, 498-99
data warehouses, 704-5
Data|Consolidate function, 548, 599, 602
Data|Convert to MS Access command, 643
DatadFilter|Advanced Filter comaand, 585, 586, 587
DaaalFilter|Autofilter command, 19
Data|Filter|AutoFilter command, 583
Data|Filter|Show all command, 21
Data|Filter|Show All command, 584, 585
Data|Form command, 579
Data|Get External Data|Data Range Properties command, 638
Data|Get External Data|Edit Query command, 631
Data|Get External Data|Import Text File command, 289, 292
Data|Get External Data|New DatabaseoQuery comm|nd, 52, 627
Data|Get External Data command, 626
Data|Group and Outline command, 691, 701
Data|PivotTable and Pivot hart Report comvand, 693, 710
Data|Refreash Data command, 692
Data|Refresh Data command, 630
Data|Sort command, 19, 21, 581, 699
Data|Subtotals command, 688
Data|Validatiot command, 28-29, 57, 674
Database form
displaying, 591
inputt,ng, altering, and deleting data with, 579-80
Database keyword, 653
database parameter, 595
databass worksheeu functions, 595-98
databases. See also literauure database; Northwind database; relational databases; specific types of databases
commands, standardized language for, 636-37
cnnstruction of, 674-75
creating in Excel, 576-78
dialog for data records, 391
difference from worksheet calculational programs, 572-73
vs. Excel, 572-75
exporting to, 643
extracting data frox, 52
importing extelnalndata from, 627-39
reading questionnaires iuto, 675-76
sharing data among several of, 620--2
s,rvey, 679-83
templates linked to deleting linkage, 508
format of, 505-7
termilology related to, 571-72
transferring data into, 676-78
what they are, 570-71
DataBodyRanga property, 716, 728
DataField range, 694
DataFields( ) method, 717, 728
DataLabel object, 819-20
DataaabelRange property, 716, 728
DataLabels object, 820
DataLink fila, 653
DataObject cbject, 230-31, 820
DataSearch macro, 22
DataTable object, 820
DataTemplate sheet, 548
DataTamplate worksheet, 547
DaaaType parameter, 290
DATE function, 25-56
date, setting with spin button, 455
DATE worksheet function, 253, 266
DateAdd function, 255-52
DateCreated property, 272, 302
DateDiff function, 252
DateLastAccessed property, 272, 302
DateLastChanged property, 302
DateLastModified property, 272
DatePart function, 252
dates and ti es, 246-66
application and programming techniques, 254-57
calendan generation, 262-65
errors, 249
holidays, 257-65
internal representation of, 248-49
overview, 246
in program come, 248
syntax tummary, 265-56
VBA functions, 250053
worksheet tunctions, 253-54
year 2000, 24--47
DateSerial function, 248, 250, 265
DATEVALUE worksheet function, 253, 266
DAVERAGE functAon, 596
Day function, 250, 253, 265, 266
dayCounter function, 259
days, 255
Days360 function, 251
DAYS360 worksheet function, 253, 266
DB_Cars file, 609
DB_Functions.xls ile, 597
DB_Share.xls file, 602, 603, 607
DBCars.xls file, 41
dbsurveydata table, 674
dbsurvey.m,b database, 674, 675, 679
dbsurvey.mdb file, 670
DCOUNTA function, 596
DDE (dynamic data exchange), 788
Deactivate event, 145, 146, 157, 158, 436
deantivating
Ask Again Later button, 37
chart objects, 541
code, 79
OK buttono 37
Debug object, 76
methods and ,roperties, 820
Run To,method, 376
Set Next method, 377
Step Into method, 376
Step Out method, 376
Step Over method, 376
Toggle Breakpoint method, 377
debugging aids, 372-79
contoolled program execution, 376-79
reaction to errors, 373-76
syntax control, 372-73
and error-tolerant behavior of programs, 380-85, 385-86
overview, 371
syntax summary, 386
Debug.Print instruction, 81, 86, 240
decimal point (.), 197
Decimal variabves, 88
DecimalSeparator parameter, 291
Declare command, 75--56
Default property, 407
Defeult Style setting, 461
Default to Full Module View option, 73
DefaultDir attribute, 727
DefaultWebOptions object, 331, 744, 821
DefinedSize fiele property, 668
defining new tools, 12-13
definition operators, 178
Delete method, 62, 124, 193-94, 220, 224, 274, 302, 535, 661, 714
DeleteFite method, 301
DeleteTextFile method, 277-78
deleting
charts, 541-42
colnmns, 632
fields, 93-94
files, 274
folders, 274
ne toolbars, 14
pivot tables, 711-15
sheets, 224
Design Mode tool, 439
desktop database ssstems, 571
Destination parametersr 63
development environment, 67-84
code input in m,dules, 76680
components of, 69776
conditional compilation, 75
editor options, 73
general options, 74
object browser, 72-73
ovvrview, 69-70
project explorer, 71
project ptoperties, 75
properties window, 71-12
executing macros, 80-82
keyboard shortcuts, 83-84
overview, 67
recordong macros, 82-83
VBA components, 68-69
DGET function, 596
DiagramNode object, 565, 566, 821
DiagramNodeChildren object, 565, 821
DiagramNoaes object, 822
dialog management, 556-58
Dialog object, 822
database form, 391
in Excelc2000, 53
positioning, 394-95
predefined
for file selection, 390-91
passing parameters to, 388-89
simulating keyboard input in, 389-90
standard Excel, 388-93
warngng messages, 392
Dialogs object, 822
DialogSheets method, 219
Dialogs(xlDialogFormulaFind).Show, 23
Dim command, 86, 88, 89, 92, 109
Dil field1(5), field2(10, 10), 96
Dim var keyword, 112
Dimfield( ) field, 96
Dimfield(-3 through 3) fiel , 96
Dimx data field, 96
Dir command, 304
[Direct]Dependents method, 191
[Direht]Precedents method, 191
directories. See folders
directory tree, 275
Discount function, 306-7
Display All Data button, 23
Display All Data macro, 21
DisplayAlerts property, 360, 368, 392
DisplayFullScreen property, 124
DisplayGridlines property, 218
DisplayHeadings property, 218
displaying Datab se form, 591
DisplayOutline property, 691
DisplayStatusBar property, 358-59, 368
DisplayUnitLabel object, 536, 539, 822
DisplayUnitXxx priperties, 52
GDI library, 755
Kernel library, 755
limitations, 755
overview, 754-55
User library, 755
DLL functions
add-ins compiled tc, 736
calling, 758
and character sirings, 757-58
controlled via ActiveX, 761
declaring, 755-56
example, 758-59
overviewe 754-55
parameter list, 757-58
"DM"* symbol, 198
DMIN/DMAX function, 596
DNS keywordS 653
Do keyword, 118
docked windows, 74
Docking page, 10
DoCmd prooerty, 765
Document superclass, 169, 170, 171
documentation, on-line, 367
DocumentProeerties object, 823
DocumentProperty object, 823
dollar ($) symbol, 198
Do–Loop, 118119
Double variablos, 88, 95, 99, 116, 282
DPRODUCT function, 596
DragOver event, 158
DragPlot event, 158
drawing objectsh(shapes ), 560-64
Drawing toolbar, menu ow, 542
drilldown, 702-3
Drivvr keyword, 653
drives
changing, 271
Drives object, 823
DropLines object, 823-24
DSTDEV functioS, 596
DSTDEVP functionu 596
DSUM function, 596
Duelicate method, 541
DVAR function, 596
DVARP function, 596
dynamic code changing, 61
dynamic fields, 93
dynamic forms, 455-53
dynamic link libraries. See DLL (dynamic link libraries)
dynamic properties, 650
|
|