Àâòîðèçàöèÿ
Ïîèñê ïî óêàçàòåëÿì
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
Ïðåäìåòíûé óêàçàòåëü
SetDataBinding methods 313
SetFocus methods 156
SetSecurity custom action 526—527
Setup project, SetSecurity custom action 526—527
Setup project, UpdateManifest action project 526
Setup project, Visual Studio bootstrapper 525
Shape objects 402
Shared add-ins, IDTExtensibility2 interface 461—462
Shared add-ins, versus VSTO add-ins 461—465
Shared assemblies 109
Shared Workspace task pane 259
SheetActivate events/event handlers 343 346
SheetBeforeDoubleClick events/event handlers 343
SheetBeforeRightClick events/event handlers 344
SheetCalculate events/event handlers 344
SheetChange events/event handlers 344\
SheetDeactivate events/event handlers 344 346—347
SheetFollowHyperlink events/event handlers 344
SheetPivotTableUpdate events/event handlers 344
SheetSelectionChange events/event handlers 344
Short data type 115 141 142
Shortcut names, code snippets 60 136
Shortcut names, question mark (?) and TAB key 136
Shortcut names, TAB key 136
Show methods 165—166
ShowDialog methods 166
Shutdown events/event handlers, chartsheets 342
Shutdown events/event handlers, documents 264
Shutdown events/event handlers, Outlook 471—472 482
Shutdown events/event handlers, ThisAddin class 580
Shutdown events/event handlers, workbooks 344
Shutdown events/event handlers, worksheets 337
Shutdown methods 461
simple data binding 169
Single assemblies (DLL files), manifests 124
Single data type 115—116
size property 155 156
Smart Documents 12
Smart documents, customizing task panes 175
Smart documents, ISmartDocument interface 13
Smart documents, ITO versus smart documents 348
Smart tag panels 58
Smart Tags 12
Smart tags, adding controls to actions pane 426
Smart tags, Click and BeforeCaptionShow events 434—435
Smart tags, creating 429—430 433—434
Smart tags, Excel 348—349
Smart tags, ISmartTagAction interface 417
Smart tags, ISmartTagRecognizer interface 417
Smart tags, options 418—421
Smart tags, properties, Actions 426—429
Smart tags, properties, Actions, Caption 427 435
Smart tags, properties, Actions, Expressions 422 427
Smart tags, properties, Actions, SmartTagType 428
Smart tags, properties, Actions, Terms 422 428
Smart tags, regular expressions, adding to smart tag Expressions property 422 427
Smart tags, regular expressions, overriding recognizers 446—451
Smart tags, regular expressions, recognizing patterns of text 440—446
Smart tags, regular expressions, recognizing phrases 436—440
Smart tags, Smart Tag Actions button 418 425
Smart tags, SmartTag class 422
Smart tags, VSTOSmartTags collection 422
SmartTagType property 428
SnycEvent events/event handlers 344
Solution Explorer 37—44
Solution Explorer, default code files 40—41
Solution Explorer, hidden code files 40—41
Solution Explorer, MyProject node 48
Solution Explorer, project items 44
Solution Explorer, References node 120
Solution Explorer, solution nodes 42—43
Solution Explorer, View Code 35
Solution Explorer, View Code, options 23 24
Solution Explorer, View Designer options 23 24
Solution Explorer, Visual Studio IDE 32
Solution nodes 42—43
SortedList class 118
SpellCheck events/event handlers 217
Spin controls 153
SpinButton controls 155 162
SplitButton controls 610
SplitContainer controls 376
splitter controls 376
STACK 115
StackOrder property 191—194
StartCaching methods 239 319
startPosition property 167
Startup events/event handlers, chartsheets 342
Startup events/event handlers, customizing actions pane 176
Startup events/event handlers, documents 264
Startup events/event handlers, Outlook 470—471 482
Startup events/event handlers, ThisAddin class 580
Startup events/event handlers, workbooks 190—191
Startup events/event handlers, worksheets 337
Startup methods 214—215 461
StartupEvent events/event handlers 482
StartUpPosition property 166
State of buttons 357
StatusStrip controls 376
Stepping into, over, and out of code 70
StopCaching method 240
Stream class 118
String Collection Editor 407
StringBuilder class 119
Strings as objects 142—144
Strings, converting data types to strings 142 144
Strings, fixed-length 145
strings, functions 119 144
Strings, reference types 115—116
Strings, String data type 116 118
Structured versus VBA-style error handling 152
Style property 159
Styles and Formatting task pane 183—196 630—636
SyncEvent events/event handlers 264
Synchronous files 118
System namespace 115—116 118 140
System.Collections namespace 118
System.Collections.Generic namespace 104
System.Data namespace 118
System.DateTime data type 141 142
System.Decimal data type 142
System.Drawing.Color type 165
System.Int16 and System.Int32 data types 142
System.IO namespace 118
System.Object data type 142
System.Object namespace 115
System.Reflection namespace 113
System.Text namespace 119
System.Text.RegularExpressions namespace 440
System.Windows.Forms namespace 51 119
System.Windows.Forms.Form namespace 544
System.Windows.Forms.UserControl namespace 544
System.Xml namespace 119
TAB key, shortcut names 136
TabControl controls 155 161 376
Table Of Contents see “Contents Help
TableAdapter ADO.NET object 316
TableLayoutPanel controls 376
TabStrip controls 155 161
Task panes, accessing through CommandBar object 178—179 (see also “Actions panes” “Document “Custom
Task panes, action pane controls, adding 183—184 (see also “Actions panes” “Document “Custom
Task panes, action pane controls, stacking order 190—194 (see also “Actions panes” “Document “Custom
Task panes, ActionsPane object 176 (see also “Actions panes” “Document “Custom
Task panes, control stacking order 190—194 (see also “Actions panes” “Document “Custom
Task panes, customizing 12—13 173—174 “Document “Custom
Task panes, relocating 190 (see also “Actions panes” “Document “Custom
Task panes, sizing/resizing 179 183 “Document “Custom
TaskItem property 481 496
TaskRequestAcceptItem property 481
TaskRequestDeclineItem property 481
TaskRequestItem property 481
TaskRequestUpdateItem property 481
Templates see “Project templates”
Terms property, smart tags 422 428
Terms property, smart tags, overriding recognizers 446
text property 155 159—161
Text, regular expressions, recognizing patterns 440—446
Text, regular expressions, recognizing phrases 436—440
Text, System.Text namespace 119
TextBox controls 119 155 156 158—159 376 382 407
ThisAddin class 579—581
ThisApplication class 214—215 475—476 482
ThisDocument class 143—144
ThisDocument class, Me keyword 208
ThisDocument.Designer.vb and .xml files 24—25
ThisDocument.vb source file 24—25
ThisWorkbook class 424
Timer controls 376
Toggle Breakpoint, Debug menu 67
Toggle controls 153
ToggleBoldItalic method 601
ToggleButton controls 155 160 617—618
ToOADate methods, Date data type 141—142
Toolbars buttons, adding graphics 355—361
Toolbars buttons, creating 352—355
Toolbars buttons, customizing 33
Toolbars buttons, Menus and Toolbars Windows Forms controls 366—367
Toolbars buttons, Outlook 482—486
Toolbars buttons, Visual Studio IDE 32—35
Toolbox 50—52
Toolbox, Visual Studio IDE 32
Toolbox, Windows Forms controls 153 154 390—391
Tools menu, Options, AutoCorrect 418—421
Tools menu, Options, Debugging tab, Break When Exceptions Cross… 63 64
Tools menu, Options, General tab, Enable Just My Code 72
ToolStrip controls 377
ToolStripContainer controls 377
ToolTip component 156
ToolTip controls 377
ToolTipText property 156
toString() methods 142 144
Trace points 68
TrackBar controls 377
transparent proxies 64—65
TreeView controls 377
Trust Assemblies Location property 504—505
Try Catch statements 112—113 150—151
Try Catch statements, debugging add-ins 486
Try Catch statements, error handling 275
Type declarations, code snippets 60
Types see “Data types; reference types” “Value
Type_TransparentProxy objects 65
UDFs (user defined functions) 547—550
Unmanaged code 89
Unmanaged code, Using statements 137—138
UpdateManifest action project 526
URL evidence code groups 500
User defined functions (UDFs) 547—550
UserForm’s ActiveX controls, migrating to VSTO 534—542
UserForm’s ActiveX controls, versus Windows Forms controls 152—156
UserForm’s ActiveX controls, versus Windows Forms controls, functionality changes 162—170
UserForm’s ActiveX controls, versus Windows Forms controls, members 156—162
UserProperty property 496
Using statements 137—138
Validate event 156
Validating event 156
ValidationError events/event handlers 256—257
Value property 159—162
value types 115—116 145—146
Variables, declaring, explicitly typing 147
Variables, declaring, Visual Basic 2005 versus VBA 147—148
Variables, late versus early binding 148
Variables, private member variables 93
Variant data type 141 142 147 274
VBA (Visual Basic for Applications), advantages for developers 5
VBA (Visual Basic for Applications), interoperability with VSTO, Excel projects 548 550—553
VBA (Visual Basic for Applications), interoperability with VSTO, user defined functions 547—550
VBA (Visual Basic for Applications), migrating solutions to VSTO, strategies 532—534
VBA (Visual Basic for Applications), migrating solutions to VSTO, Word projects 534—542
VBA (Visual Basic for Applications), moving to Visual Basic 2005 129—130
VBA (Visual Basic for Applications), Office solutions 15—16
VBA (Visual Basic for Applications), procedural programming 91
VBA (Visual Basic for Applications), unmanaged code 89
VBA (Visual Basic for Applications), versus Visual Basic 2005, ActiveX and Windows Forms controls 152—170
VBA (Visual Basic for Applications), versus Visual Basic 2005, converting VBA macros 209—213
VBA (Visual Basic for Applications), versus Visual Basic 2005, data types 140—145
VBA (Visual Basic for Applications), versus Visual Basic 2005, default properties 148—149
VBA (Visual Basic for Applications), versus Visual Basic 2005, enumerations 149
VBA (Visual Basic for Applications), versus Visual Basic 2005, exception handling 150—152
VBA (Visual Basic for Applications), versus Visual Basic 2005, methods 145—146
VBA (Visual Basic for Applications), versus Visual Basic 2005, scope 147—148
VBA (Visual Basic for Applications), versus Visual Basic 2005, variable declaration 147—148
VBA (Visual Basic for Applications), versus VSTO 208—209
VBA (Visual Basic for Applications), Visual Basic 2005 events/event handlers 245
VBA (Visual Basic for Applications), VSTO as alternative 3
VBE (Visual Basic Editor), Office solutions 15—16
VBE (Visual Basic Editor), VSTO as alternative 3
VbModal and vbModeless properties 165—166
View Code, Solution Explorer 23 24 35
View Designer, Solution Explorer 23 24
View menu, Code 35
View menu, Object Browser 47
View menu, Toolbox 52 390—391
Visio project templates 21—22 576 578
Visual Basic 2005 3
Visual Basic 2005, managed code 89—91
Visual Basic 2005, moving from VBA 129—130
Visual Basic 2005, new features 130—131
Visual Basic 2005, versus VBA, data types 140—145
Visual Basic 2005, versus VBA, default properties 148—149
Visual Basic 2005, versus VBA, enumerations 149
Visual Basic 2005, versus VBA, events/event handlers 245
Visual Basic 2005, versus VBA, exception handling 150—152
Visual Basic 2005, versus VBA, methods 145—146
Visual Basic 2005, versus VBA, scope 147—148
Visual Basic 2005, versus VBA, variable declaration 147—148
Visual Basic 6.0, unmanaged code 89
Visual Basic Developer Center 651
Visual Basic Editor see “VBE (Visual Basic Editor)”
Visual Basic for Applications see “VBA”
Visual Basic Migration Wizard 130
Visual C# 3
Visual C#, managed code 89—91
Visual C#, moving from C++ 129—130
Visual Studio 2005 Tools for Office see “VSTO”
Visual Studio 2005 Tools for Office, Second Edition see “VSTO 2005 SE”
Visual Studio 2005 Tools for the Microsoft Office System 3
Visual Studio IDE 27—28
Visual Studio IDE, auto-completion of keywords and enumerations 28—56
Visual Studio IDE, bootstrapper 525
Visual Studio IDE, code view 35—37
Visual Studio IDE, Data Sources window 52 53
Visual Studio IDE, environment settings 28—29
Visual Studio IDE, menus and toolbars 32—35
Visual Studio IDE, Object Browser 46—48
Visual Studio IDE, object-oriented programming 91
Visual Studio IDE, Project Designer 48—50
Visual Studio IDE, Properties window 44—46
Visual Studio IDE, Solution Explorer 32 37—44
Visual Studio IDE, Toolbox 50—52
Visual Studio Project Wizard 30—31
Visual Studio Team System, standalone version 3
VScrollBar controls 155 162 377
VSTO (Visual Studio 2005 Tools for Office), .NET Framework Class Library 109
VSTO (Visual Studio 2005 Tools for Office), add-ins, IStartup Interface 461—462
VSTO (Visual Studio 2005 Tools for Office), advantages for developers 5—6
VSTO (Visual Studio 2005 Tools for Office), code files 23—25
VSTO (Visual Studio 2005 Tools for Office), customizing Office 2003, applications 3
VSTO (Visual Studio 2005 Tools for Office), features 7—8
VSTO (Visual Studio 2005 Tools for Office), integrating with Visual Studio 22—23
Ðåêëàìà