dll in, 320
running examples on, 43
With...End With block
adding to For...Next loop, 309
setting array elements within, 214
wizard-style UserForms, creating, 150??“191
Word
creating an instance of, 291??“295
creating report in, 287??“298
opening and loading new document into,
291
Word 2007 DOM, creating summary report
using, 287??“298
Word objects, displayed in the Object
Browser, 298
workbook
adding custom ribbon to, 119??“131
importing data into, 47??“48
macro code generated error, 47??“48
Workbook object, XmlImport method of, 99
workbook.xml.rels file, contents of, 125
Worksheet property, HRWizard application,
170
nX
XIXmlImportResult members, in Object
Browser window, 102
xl folder contents, 123
\xl\connections.xml file, 126??“127
nINDEX 360
xl\queryTables\queryTable1.xml file,
127??“128
xlAutoFillType enumerations, table of, 18??“19
xlChartType data type, enumerations,
198??“200
XlConsolidationFunction enumeration,
choices for Function property,
241??“242
xlPivotFieldOrientation enumerations, table
of, 231
XlRowCol, enumerations, 202
XML, using in Excel 2007, 99??“132
XML data
appending or overwriting in workbook,
106??“107
saving, 107??“108
XML data class, building, 108??“119
XML_data.xlsm
downloading and opening, 276
Debugging and Error Handling, 249??“286
XML file
creating to modify the UI, 129??“131
imported, 103
XML maps, 102??“106
XML Schema dialog box, 102
XML schemas. See XML maps, 132
XML Source window, with artist element
selected, 104
XmlImport function and arguments, 101??“103
XmlImport method
appending XML data with, 106??“107
of Workbook object, 99
XMLMaps collection, DataBinding
property Refresh method, 105??“125
nINDEX 361
Offer valid through 9/08.
Pages:
312
313
314
315
316
317
318
319
320
321
322
323
324