NET
advantages of vs. ActiveX, 323
in Excel 2007 programming, 315
using to retrieve data, 327??“328
.NET components, using in Excel, 323??“349
New command button
code for UserForm1, 146
testing, 149
New Employee UserForm, creating, 344??“348
New Project dialog box, VS 2005 for MS Office
2003 projects, 324
!Northwind2Excel Object, 321??“322
number format, changing, 242
Number Format property, 242
Nwind2Excel.dll
registering in Windows XP, 2000, or Vista,
319??“320
web site address for downloading, 319
NWindData class module, 333??“334
nINDEX 356
NWindData.vb
adding code to class, 332??“335
changing class name to, 331??“332
NWindDataAccess project, adding to
Solution Explorer, 335
NWindDataAddIn project
creating, 327??“328
NWindDataAddInSetup deployment
project, 335
NwindEmps01.xlsx file, downloading and
renaming, 125
nO
object, definition of, 30
Object box, in code window, 8??“9
Object Browser
displaying, 24??“25
window elements, 25??“27
Word objects displayed in, 298
object-oriented programming (OOP)
overview, 39??“41
solutions in Excel, 87??“96
Wikipedia Object_database for, 172
ODBC
importing Access data using, 60??“65
importing SQL data using, 65??“67
retrieving Access 2007 code via, 62??“63
running the code, 63??“65
Office 2007 Add-in projects, added in
VSTO SE in Windows Vista, 326??“327
office integration, 287??“314
OLE DB (Object Linking and Embedding
Database), successor to ODBC, 67
OLEDB library, referencing, 333
On Error GoTo statement
adding to turn on error trapping, 285
syntax for error handling, 275
Open XML format, file container, 120
Option Explicit, 252??“253
OptionButton, in Toolbox window, 38
Options dialog box, showing VBE color
options, 264
Overwrite arguments, for appending XML
data, 106??“107
nP
PageSettings property, adding to
cStepManager class, 175??“176
Parameter objects
appending to Parameters collection, 86
creating ADO and adding to Command
object, 70
instantiating and setting properties, 85
Parameters collection, appending Parameter
objects to, 86
personal information page, adding controls
to, 154??“156
pie charts
creating, 206??“211
dynamically placing, 216??“221
looking at the code, 210??“211
making selection for, 206??“207
moving on worksheets, 211??“212
selecting, 208
setting name of data series in, 211
storing data correctly for, 202??“206
summarizing with, 202??“221
updated, 210
PivotCaches.
Pages:
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324