xml file, creating, 129??“131
cXML class
adding client code to test, 113??“117
adding properties to, 109??“110
building functions for, 110??“119
putting data on worksheets, 110
nD
DAO. See Data Access Objects (DAO)
DAO examples
adding reference to DAO library, 55??“56
importing Access data using Jet, 55??“59
importing Access data using ODBC, 60??“65
importing SQL data using ODBC, 65??“67
DAO Jet object model, 54
DAO library, adding reference to, 55??“56
DAO objects, common, 54??“55
DAO ODBC
object model, 60
result from Northwind Customers table,
65
data access code, macro generated, 44??“45
data access component, creating, 328??“335
Data Access Objects (DAO), using in Excel
2007, 54??“67
data entry form
creating simple, 133??“150
creating wizard-style UserForms, 150??“191
data import tools, in Excel 2007, 43??“54
data orientation, switching from column to
row, 196??“197
Data Preview window, with Text data type
applied, 51
data range and legend information, defining
and setting, 218??“220
Data ribbon, Sort command on, 203
Data tab, Switch Row/Column command on,
197
data table, formatting, 16??“17
DataAccessSample02.xlsm workbook,
creating, 48??“50
DataAccessSample05.xlsm workbook,
creating, 80??“82
DataBindings.LoadSettings method, 106
DataRegionStart property, using, 89??“90
Debug menu, 249
and toolbar commands, 250??“251
options for stepping through code,
261??“267
Debug object, 253
toolbar, 249, 252
using, 257??“260
Debug.
Pages:
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324