D
databases appending worksheets to, 40-46 closing, 45-46 connection to PivotTables, 263 defining range, 41 editing connection string, 263 importing data, 259-61 opening dBase files in Excel, 41 redefining, 41-42
DataBodyRange property, 135
data connection files, relationship to PivotTables, 264
Data Connection Wizard, 259-61
data fields adding second one, 133 assigning to variables, 133 creating, 134 naming, 134-35 vs. other fields, 133 overview, 133 removing, 134
DataFields collection, 130
DataLabelRange property, 136
Data Link Properties dialog box, 260
data types, converting, 166
Data worksheet creating formulas from range addresses, 114-16 Return to Menu command and, 286
Date function, 234
dates adding to records via AddDates macro, 38-40 checking validity of data entry, 145-46 finding, 243-44 initializing in Print Options text box, 234 prompting for entry via TestInput macro, 144-46 testing formats, 146
dBase. See databases
DblClick event, 198
Debug menu, 158
Delete method, 64
DeleteSheet macro, 174-75
Design Mode button, 214
dialog boxes. See user forms
digital signatures adding to VBA projects, 21 authentic, 22 creating, 19-21 trusting, 22 ways to obtain, 19
directories, listing files via ListFiles macro, 153-55
Dir function, 153
DisplayAlerts property, 47
DisplayGridlines property, 14
dockable views, 57-62
dollar sign ($), absolute references
Do loop in ListFiles macro, 153-55 in MakeNextReport macro, 177-78 overview, 155
drawing objects Excel vs. Office, 87 overview, 69 vs. shapes, 87
DrawingObjects class, 76-77
Drawing toolbar, 276
drop-down list boxes, 217-20 |