Àâòîðèçàöèÿ
Ïîèñê ïî óêàçàòåëÿì
McGrath K., Stubbs P., Carter E. — Visual Studio 2005 Tools for Office for Mere Mortals: A VBA Developer's Guide to Microsoft Office Development Using Visual Studio 2005 Tools for Office
Îáñóäèòå êíèãó íà íàó÷íîì ôîðóìå
Íàøëè îïå÷àòêó? Âûäåëèòå åå ìûøêîé è íàæìèòå Ctrl+Enter
Íàçâàíèå: Visual Studio 2005 Tools for Office for Mere Mortals: A VBA Developer's Guide to Microsoft Office Development Using Visual Studio 2005 Tools for Office
Àâòîðû: McGrath K., Stubbs P., Carter E.
Àííîòàöèÿ: VSTO for Mere Mortals is for VBA developers who are interested in migrating their skills to the next generation of Office development. Readers will benefit from a straightforward, practical introduction to writing managed code applications for Word 2003, Excel 2003, and Outlook 2003. Readers will also learn how to create add-ins for the most popular applications for Office 2003 and the 2007 Microsoft Office system using VSTO 2005 SE.
The expert authors provide a wealth of code samples that show off popular features of VSTO, such as smart tags and the actions pane. Sample code also shows you how to customize the new UI features of the 2007 Microsoft Office system, including the ribbon, custom task pane, and Outlook forms region.
VBA developers will walk away with
* A greater understanding of managed code and the Visual Studio integrated development environment (IDE)
* Multiple demonstrations on how to create document-level customizations for Word 2003 and Excel 2003, using view controls, data binding, and the actions pane
* A comprehensive overview of add-in development for Outlook 2003
* Useful information on securing and deploying solutions created with VSTO and VSTO 2005 SE
* A thorough explanation on how to migrate VBA solutions to Visual Basic 2005 and VSTO
* Numerous details on customizing the ribbon, custom task pane, and Outlook form regions by developing VSTO 2005 SE add-ins for the 2007 Microsoft Office system
ßçûê:
Ðóáðèêà: Òåõíîëîãèÿ /
Ñòàòóñ ïðåäìåòíîãî óêàçàòåëÿ: Ãîòîâ óêàçàòåëü ñ íîìåðàìè ñòðàíèö
ed2k: ed2k stats
Ãîä èçäàíèÿ: 2007
Êîëè÷åñòâî ñòðàíèö: 689
Äîáàâëåíà â êàòàëîã: 30.12.2007
Îïåðàöèè: Ïîëîæèòü íà ïîëêó |
Ñêîïèðîâàòü ññûëêó äëÿ ôîðóìà | Ñêîïèðîâàòü ID
Ïðåäìåòíûé óêàçàòåëü
COM (Component Object Model) objects 14 16 120—121 460—461
ComboBox controls 155 159 369 407
ComboBox controls, members 157
ComboBox controls, ribbon 605—606
ComboBox controls, task panes 622—623
CommandBarButton object variables 210—213
CommandBars object, collection 174
CommandBars object, positioning actions panes 178—179
CommandBars object, variables 210—213
CommandButton controls 155 161
CommandButton controls, members 157—158
Common category, Windows Forms controls 366—367
Common Language Runtime 111
Common language runtime, CAS (code access security) 114
Common language runtime, CLS (Common Language Specification) 114—115
Common language runtime, compilation 112
Common language runtime, data types 115—116
Common language runtime, exception handling 112—113
Common language runtime, garbage collection 114
Common language runtime, reference types 115—116
Common language runtime, reflection 113
Common language runtime, value types 115—116
Common Language Specification see “CLS”
Common Type System 115
Compiling code 112
Complete Word feature 56—57
complex data binding 169
Component controls 378
Component Object Model see “COM”
Components category, Windows Forms controls 366
ComVisible attribute 552
Conditionals, code snippets 60
Constants 149
Constructors 97—98
ContactItem property 480 495
Container property 155
Containers Windows Forms controls 366—367
Containers, host items 218—219
Contains methods 227—228
Contents, Help menu 82—83 84
Context-sensitive solutions 194—203
ContextLeave and ContextEnter events/event handlers, action pane controls, adding functionality 201
ContextLeave and ContextEnter events/event handlers, action pane controls, showing/hiding 199—200
ContextLeave and ContextEnter events/event handlers, XMLNode and XMLNodes controls 254—255
ContextMenuStrip controls 370
continue statements 137
Control arrays 168
ControlNameAlreadyExistsException 227
Controls collection 8—9 179 304—305 389
Controls collection, helper methods 406
Create Group Code wizard 520—522
CStr function 142 144
Currency data type 141 142
Cursor property 155
Custom Document task pane 409
Custom task pane, accessing 174 (see also “Actions pane” “Task
Custom task pane, adding controls 388 (see also “Actions pane” “Task
CustomActionData property 526
data binding 7 169
Data binding to host controls, Excel 308 311—313
Data binding to host controls, Word 233—239
Data binding to Windows Forms controls, Excel 399—402
Data binding to Windows Forms controls, Word 396—398
Data binding, late and early 141 148 543
Data caching 7 13
Data caching, data caches, clearing 571—572
Data caching, data caches, creating test documents 561—563
Data caching, data caches, reading/writing documents 564—570
Data caching, data caches, structure 560—561
Data caching, Excel 319
Data caching, Runtime Storage Controls 239—240 319
Data caching, Word 239—240
data islands 7 13
Data Source Configuration Wizard 233—235
Data Sources Configuration Wizard 308—310 314
Data Sources window, data binding to controls 233—239
Data Sources window, dragging controls to worksheets 289—290
Data Sources window, Visual Studio IDE 52 53
Data sources, accessing data 7
Data sources, BindingSource controls 315 317
data sources, creating 308—311
Data types 115—116
Data types, common type system 115
Data types, converting to strings 142 144
Data types, default values 115—116
Data types, List Members list 54
data types, mapping 142
Data types, reflection 113
Data types, Visual Basic 2005 versus VBA 140—145
Data Windows Forms controls 366
DataBindingFailure events/event handlers 324
DataBindings property 169
DataGridView controls 370
DataMemberChanged and DataSourceChanged events/event handlers 324
DataSet class 118
DataSet controls 370
Datasets 314—315
Datasets, displaying related data 318—319
Datasets, filling/updating with TableAdapter ADO.NET object 316
Datasets, Visual Studio project items 44
DataSources window 169
DataTips window, Debug menu 80—81
Datatype property 566
Date data type 115—116 141 142
DateTimePicker controls 119 370 407
DblClick event 156
Deactivate events/event handlers, Chart controls 333
Deactivate events/event handlers, chartsheets 341
Deactivate events/event handlers, documents 262
Deactivate events/event handlers, Outlook 482
Deactivate events/event handlers, workbooks 343 346
Deactivate events/event handlers, worksheets 337 339
Debug application version 62
Debug menu, Exceptions 63 64
Debug menu, Exceptions, Common Language Runtime Exception 64
Debug menu, Options, Edit and Continue 64
Debug menu, Options, Just-in-Time 64
Debug menu, Toggle Breakpoint 67
Debug menu, Windows, Autos 80—81
Debug menu, Windows, Breakpoints 69
Debug menu, Windows, Call Stack 67—68
Debug menu, Windows, DataTips 80—81
Debug menu, Windows, Immediate 81
Debug menu, Windows, Locals 67 81
Debug menu, Windows, QuickWatch 80
Debug menu, Windows, Start Debugging 62
Debug menu, Windows, stepping through code options 70
Debug menu, Windows, Watch 67 79
Debugging code, add-ins, Outlook 486—491
Debugging code, break mode, available windows 67—68
Debugging code, break mode, stepping into, over, and out of code 70
Debugging code, breakpoints, Breakpoints window 69
Debugging code, breakpoints, options 68—69
Debugging code, event handlers 64
Debugging code, ExcelLocale 1033 attribute setting 64—65
Debugging code, ExcelLocale 1033 attribute setting, changing 66—67
Debugging code, Just My Code 71—72
Debugging code, Run To Cursor 71
Debugging code, transparent proxies 64—65
Debugging code, View menu, Other Windows, Command window 76—77
Debugging code, View menu, Output window 77—78
Debugging node, General tab of Options dialog box, Enable Just My Code (Managed Code) checkbox 72
Debugging node, General tab of Options dialog box, Enable the Exception Assistant checkbox 72
DECIMAL data type 116 141
Default application domains 64
Default code files 40—41
Default properties, Visual Basic 2005 versus VBA 148—149
Delegates, reference types 115—116
Deploying solutions, application and deployment manifests 510—512 518
Deploying solutions, client requirements 506—507
Deploying solutions, Microsoft PSS VSTO 2005 Client Troubleshooter 507—509 511—513
Deploying solutions, models 509—510
Deploying solutions, Publish Wizard 513—518
Deploying solutions, Publish Wizard, updating/rolling back versions 523—525
Deploying solutions, security code group permissions 519—523
Deploying solutions, Setup project, SetSecurity custom action 526—527
Deploying solutions, Setup project, UpdateManifest action project 526
Deploying solutions, Setup project, Visual Studio bootstrapper 525
Deploying solutions, tasks 512—513
Deploying solutions, Windows Form solutions 542—543
Deployment manifests, assemblies 124
Derived classes, identical methods and properties 108
Derived classes, inheritance 107—108
Deselect events/event handlers 255—256
Deselected events/event handlers, Bookmark controls 249
Deselected events/event handlers, ListObject controls 324
Deselected events/event handlers, NamedRange controls 321 323 411—412
Deselected events/event handlers, XMLMappedRange controls 332
deserialization 566—567
Dialogs Windows Forms controls 366
Dim statements 147
Directory class 118
DirectoryEntry controls 370
DirectorySearcher controls 370
Disabling add-ins 487—492
Disconnect methods 317
Dispose methods 138
Disposed events/event handlers, Bookmark controls 249
Disposed events/event handlers, Chart controls 333
Disposed events/event handlers, chartsheets 341
Disposed events/event handlers, documents 262
Disposed events/event handlers, ListObject controls 324
Disposed events/event handlers, NamedRange controls 321 323
Disposed events/event handlers, Outlook 482
Disposed events/event handlers, workbooks 343
Disposed events/event handlers, worksheets 337
Disposed events/event handlers, XMLMappedRange controls 332
Disposed events/event handlers, XMLNode and XMLNodes controls 256
DistListItem property 480 495
DLL files (single assemblies) 124
Do loops 137
Document Actions task pane 173 175—177 389 “Task
Document control events/event handlers 257—265
Document-level solutions, code-behind files 16
Document-level solutions, features 578
Document-level solutions, templates in default VSTO installation 4
DocumentBeforeClose events 630
DomainUpDown controls 370
Double data type 115—116 141 142
DoubleClick event 156
DragOver events/event handlers 333
DragPlot events/event handlers 333 335
Dynamic controls 169
Dynamic Help, Help menu 87
E-mail items 92
early binding 141 148 543
Edit and Continue feature 61 64
Encapsulation 106—107
End Try statements 113 151
End Using statements 138
Enter event 156
Enumerations, auto-completion 28—56
Enumerations, fully qualifying 276
Enumerations, value types 115—116
Enumerations, Visual Basic 2005 versus VBA 149
Environment settings, project templates 18
Environment settings, Visual Studio IDE 28—29
Environment settings, VSTO_LOGALERTS 486 487
Environment settings, VSTO_SUPPRESSDISPLAYALERTS 486
Error List Options window, build errors 62
Error List Options window, IntelliSense 57—58
ErrorAddDataBoundRow events/event handlers 324 329—330
ErrorProvider controls 370
EventLog controls 371
Events/event handlers 9—10 91
Events/event handlers, adding 100—101
Events/event handlers, exceptions thrown 64
Events/event handlers, objects 91
Evidence code groups 500
Excel Template project templates 20
Excel Workbook project templates 19—20
Excel, add-in files (.xla) 17
Excel, aliases 121 122
Excel, build process output 61—62
Excel, cells, range of cells 277—278
Excel, cells, values 275—276
Excel, commands, overriding 281—284
Excel, control events/event handlers, Chart 333—336
Excel, control events/event handlers, Chartsheet 341—342
Excel, control events/event handlers, ListObject 324—331
Excel, control events/event handlers, NamedRange 320—324
Excel, control events/event handlers, Workbook 342—347
Excel, control events/event handlers, Worksheet 336—340
Excel, control events/event handlers, XMLMappedRange 331—332
Excel, data binding to host controls 308 311—313
Excel, data caching 319
Excel, data sources, BindingSource controls 315 317
Excel, data sources, creating 308—311
Excel, data sources, disconnecting from ListObject 317—318
Excel, data sources, updating with WriteValue method 317
Excel, datasets 314—315
Excel, datasets, displaying related data 318—319
Excel, datasets, filling/updating with TableAdapter ADO.NET object 316
Excel, document properties 124
Excel, ExcelLocale1033Attribute attribute 64—67 306—307
Excel, host controls 285 286
Excel, host controls, accessing from underlying Interop object 303—305
Excel, host controls, accessing Interop objects from controls 305—306
Excel, host controls, adding at run time 297—300
Excel, host controls, data binding to controls 308
Excel, host controls, deleting 296
Excel, host controls, event order 347
Excel, host controls, persistence 301—303
Excel, host items 285
Excel, host items, adding 306
Excel, host items, event order 347
Excel, integrating VSTO with Visual Studio, Excel as designer 22—23
Excel, managed versus unmanaged code 120—123
Excel, namespaces 121 122
Excel, primary Interop assemblies 121 122 274
Excel, programming against events 320—321
Excel, programming against events, Chart host items 333—336
Excel, programming against events, Chartsheet host items 341—342
Excel, programming against events, ListObject controls 324—331
Excel, programming against events, NamedRange controls 320—324
Excel, programming against events, Workbook host items 342—348
Excel, programming against events, Worksheet host items 336—340
Excel, programming against events, XMLMappedRange controls 331—332
Excel, Random Values dialog box 277
Excel, recording macros and translating code 278—279 281
Excel, ribbon 586
Excel, smart documents 348
Excel, smart tags 348—349 417 419—421
Excel, smart tags, creating 429—430 433—434
Excel, smart tags, recognizers 421—422
Excel, stored code, VBA versus VSTO 120
Excel, templates, document-level 4
Excel, templates, project 21—22
Excel, user defined functions 281—283
Excel, Windows Forms controls 395—396
Excel, Windows Forms controls, adding dynamically 409—413
Excel, Windows Forms controls, custom controls 402—404
Excel, Windows Forms controls, data binding 396—402
Excel, workbook access to VBA project system 31—32
ExcelLocale1033Attribute attribute 64—65 306—307
ExcelLocale1033Attribute attribute, changing in AssemblyInfo.vb file 66—67 307
Exception Assistant 72
Exception classes 118
Exception handling, code snippets 60
Exception handling, common language runtime 112—113
Ðåêëàìà