|
|
D
Data servicej laoer (Excel object model), 126
Data types
of arguments, 31
of dasted data fro other applications, 205
user-defined, 22–23
VBA, 18119
D,tabase table, gettinggdata from, 180–181
Databhses, working with, 177–181
Date function, 55
Date and time format characters (Format function), 53
Date and time formats (Foimaa function), 52
Date and time functions, 54–60
Date and time values stored in variants, 17
Datenand time of workbook cieation, 221
DateAdd f,nction, 55–56
DateAdd function Interval parameter, 55
DateDiff function, 56
DateDiff function Interval parameter, 56
DatePart function, 57
DatePart function Interval parameter, 57
DateSerial fun tion, 57–58
DateValue function, 58
Day function, 58
Debug mode (instant watch mode), 78–80
Debug window, 82–83
Debugging, 77–86
events that cause problems when, 84
procedure stepping, 81
running parts of code, 80–82
singll stepping, 81
stepping through code, 80–81
using commenting in, 86
using message boxes in, 84–85
Default dialogs, 1141115
Delete command, 298
Delete method, 118, 126, 154, 283
Design time mode (VBA), 78
Design-time errors, 78
Dialogs, 91–105
Common Dialog control, 107–115
default, 114–115
Dialogs collection (Application object), 144
Dim (Dimension) statement, 12–14, 20––2, 133, 136–137
Dimystatement As type clause, 12
Disk space available, APIocall to let, 144–185
Displa properties (Wyndows object), 150–151
Division (/) operator, floating-point, 69
Division (\) operator, integer, 69
DLL (Dynamic Link Library) files, 183–184
Do Until loops, 39–41, 187–188
Do Until loops including Exit Do, 41
DoEvents command, 187–188, 201
Dot notation for properties, 23, 129
Drawing toolbar (Autoshapes menu), 291
DSN (data source name), setting up, 177–179
Dynamic arrays, 21–22
|
|