text data import
code, 52
Access database, importing data from,
43??“46
access information page, adding controls to,
159??“160
access tab control settings, table of, 159??“160
ACE (Access Engine), 54
ActiveCell.CurrentRegion property, 236
ActiveChart.PlotBy property, 202
ActiveWorkbook object, 100??“101
ActiveX
custom functionality with, 316??“323
in Excel 2007 programming, 315
and .NET in Excel programming, 315??“350
ActiveX components
cData class from, 318
cExcelNwind class from, 319
using in Excel 2007 projects, 315??“323
ActiveX Data Objects (ADO), See ADO
(ActiveX Data Objects)
Add Reference dialog box, displaying, 335
Add Watch command, selecting, 273
Add Watch dialog box, 273
AddChart method
optional arguments, 198
placing and aligning charts with,
213??“215
address information page, adding controls
to, 156??“157
address tab control settings, table of,
156??“157
ADO (ActiveX Data Objects), using in Excel
2007, 67??“87
ADO 2.8 library, adding reference to, 67??“68
ADO Connection and Command objects,
setting up, 83??“84
ADO data type enums, 70??“71
ADO examples
importing SQL data based on a selection,
75??“80
importing SQL data, 67??“74
updating SQL data, 80??“87
ADO recordset, getting data into and placing
into worksheet, 88
ADODB.Parameter objects, filling colParams
collection with, 84??“85
ADOTest macro, VBA code, 316??“318
AdventureWorks sample database, installing,
67
AppendXMLData() method, adding to
standard module, 106
application folder, for Excel file, 123
Application object, ActiveWorkbook object as
property of, 100??“101
AutoFill method, 18
AutoFit command, formatting worksheet
with, 88, 338
AutoSum button, on Home ribbon, 17
Axis Labels dialog box
opening, 209
setting label range in, 209??“210
nB
bang (!) character
adding to custom objects, 32
basManagers module, adding in VBE, 95
Beverage category sales information,
modifying MakePieChart macro for,
212??“213
Beverage sales chart, 196
with rows and columns switched, 197
BindListToCollection method, 169
BindListToRange method, 169
BirthYear function, 254??“255
modifying to use Debug.
Pages:
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321