FrameMaker 6: Beyond the Basics

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