McGrath Kathleen, Stubbs Paul. VSTO for Mere Mortals. A VBA Developer's Guide to Microsoft Office Development Using Visual Studio 2005 Tools for Office

Addison-Wesley; Pearson Education, Inc., 2007. – 726 p.Foreword.About the Authors.
Introduction to VSTO.
Getting Started with VSTO.
Topics Covered in This Chapter.
What Is VSTO?
Why Use VSTO Instead of VBA?
Features of VSTO.
Host Items and Host Controls.
Windows Forms Controls.
Smart Tags.
Customizing Task Panes.
Caching Data in a Document.
Managed Add-ins.
Security and Deployment.
Ribbon Support.
Enhanced Development Environment.
Creating VSTO Solutions.
Creating Office Solutions with VBA.
Creating Office Solutions with VSTO.
Project Types.
How VSTO Integrates with Visual Studio.
Word and Excel as Designers.
Code Files in VSTO.Review Questions.The Programming Environment.
Topics Covered in This Chapter.
Introduction to the Visual Studio IDE.
Environment Settings.
Creating a Visual Studio Tools for Office Project.
Granting Access to the VBA Project System.
Menus and Toolbars.
Viewing IDE Windows.
Code View.
Exploring Solution Explorer.
Properties Window.
Browsing the Object Browser.
Project Properties.
Viewing Other Visual Studio Windows.
Tools for Writing Code.
Using IntelliSense.
Edit and Continue.
Building and Running Code.
Debugging Your Code.
Setting Breakpoints.
Stepping Into, Over, and Out of Code.
Trying Out the Debugging Tools.
Using Debugging Windows.
Locating and Using Help.Search.
How Do I.
Dynamic Help.Review Questions.Introduction to Managed Code.
Topics Covered in This Chapter.
What Is Managed Code?
Introduction to Object-Oriented Programming.
Understanding Classes and Objects.
Partial Classes.
Generic Classes.
Interfaces.
Object Orientation.
Exploring the.NET Framework.
Assemblies.
Namespaces.
Application Domains.
Common Language Runtime.
Common Language Specification.
.NET Framework Class Library.
VSTO and Managed Code.
Primary Interop Assemblies.
Solution Assemblies.
Running VSTO Solutions.Review Questions.Moving from VBA to VSTO and.
Visual Basic 2005.
Topics Covered in This Chapter.
Moving to Visual Basic 2005.
New Features of Visual Basic 2005.
The My Objects.
IntelliSense Code Snippets.
Statements.
Operators.
Language Differences of VBA and Visual Basic 2005.
Data Types.
Methods.
Variable Declaration and Scope.
Default Properties.
Enumerations.
Exception Handling.
UserForms Versus Windows Forms.
Comparison of ActiveX Controls to Windows Forms.
Controls.
Changes to Control Functionality.Review Questions.Word and Excel.
Customizing Word and Excel Task Panes.
Topics Covered in This Chapter.
What Is a Task Pane?
Customizing the Document Actions Task Pane.
Using the ActionsPane Object.
Managing the Actions Pane.
Managing the Size and Position of the Actions Pane.
Showing and Hiding the Actions Pane.
Designing Actions Pane Solutions.
Creating an Actions Pane Solution.
Adding an Actions Pane Control.
Accessing the Actions Pane from a Document.
Accessing the Document from the Actions Pane.
Managing Control Order.
Creating Context-Sensitive Solutions.
Creating an XML Schema.
Mapping XML Elements to Your Document.
Creating Multiple Actions Pane Controls.
Showing and Hiding Controls on the Actions Pane.
Adding Functionality to the Actions Pane Controls.Review Questions.Customizing Word with VSTO.
Topics Covered in This Chapter.
Programming in Word.
Converting a Recorded VBA Macro to Visual Basic in VSTO.
Overriding Built-In Commands.
Word Host Items and Host Controls.
Adding Host Controls to the Document.
Accessing a Host Control from an Underlying Interop Object.
Accessing an Interop Object from a Host Control.
Data Binding to Host Controls on Documents.
Binding Data to Controls.
Caching Data in the Document.
Programming Against Events.
Bookmark Control Events.
XMLNode Control Events.
XMLNodes Control Events.
Document Events.
Special Enhancements to the Bookmark.
Overlapping Bookmarks.
Making Word Documents Smart.Review Questions.Customizing Excel with VSTO.
Topics Covered in This Chapter.
Programming in Excel.
Learning About Excel’s Object Model.
Converting a Recorded VBA Macro to Visual Basic in VSTO.
Writing Callbacks from VBA into VSTO Code.
Excel Host Items and Host Controls.
Host Items.
Host Controls.
Adding Host Controls to the Worksheet.
Removing Host Controls.
Adding Host Controls at Run Time.
Control Persistence.
Accessing a Host Control from an Underlying Interop Object.
Accessing an Interop Object from a Host Control.
Adding Host Items in Excel.
The Excel Locale Issue.
Data Binding to Host Controls on Worksheets.
Creating a Data Source.
Adding Data-Bound Controls to the Worksheet.
Working with Related Data.
Caching Data in the Workbook.
Programming Against Events.
NamedRange Control Events.
ListObject Control Events.
XMLMappedRange Control Events.
Chart Control Events.
Worksheet Events.
Chartsheet Events.
Workbook Events.
Making Excel Smarter.Review Questions.Controls in Word and Excel.
Topics Covered in This Chapter.
About Controls.
Adding Controls to Toolbars and Menus.
Creating Toolbar Buttons.
Creating Menus and Menu Items.
Using Windows Forms Controls.
Available Windows Forms Controls.
Adding Controls to a Windows Form.
Creating a User Control.
Adding Controls to the Task Pane.
Adding Controls to Excel and Word Documents.
Windows Forms Controls in Word.
Windows Forms Controls in Excel.
Adding Data-Bound Controls.
Adding Custom Controls to a Document.
Control Type.
Adding Controls at Run Time.
Functionality of Windows Forms Controls on Documents.Review Questions.Smart Tags in Word and Excel.
Topics Covered in This Chapter.
What Is a Smart Tag?
Creating Word and Excel Smart Tags with VSTO.
Understanding Smart Tag Properties.
Actions Property.
Caption Property.
Expressions Property.
SmartTagType Property.
Terms Property.
Taking Action on a Smart Tag.
Events Available for an Action.
Introduction to Regular Expressions.
Using Regular Expressions to Recognize Phrases.
Recognizing Patterns of Text.
Overriding Smart Tag Recognizers.
Creating the Word Project.
Running the Code.
Going Offline.Review Questions.Outlook and Beyond.
Creating Add-ins for Outlook with VSTO.
Topics Covered in This Chapter.
Application-Level Customizations Using VSTO.
Differences Between Shared Add-ins and VSTO Add-ins.
The Outlook Add-in Project Template.
Converting an Outlook Macro to a VSTO Add-in.
Creating a Simple Add-in.
IntelliSense in Visual Studio.
Outlook Object Model Overview.
Application Object.
NameSpace Object.
Explorer Object.
Inspector Object.
Outlook Folders.
Outlook Items.
Events.
Customizing Menus and Toolbars in Outlook.
Debugging Add-ins.
Disabled Add-ins.
Security in Outlook Add-ins Created with VSTO.
Restricted Methods.Review Questions.Security and Deployment.
Topics Covered in This Chapter.
VSTO Security Model.
Code Access Security.
Deploying Word and Excel Solutions.
Client Requirements.
Microsoft PSS VSTO 2005 Client Troubleshooter.
Deployment Models.
Application and Deployment Manifests.
Deployment Tasks.
Publish Wizard.
Update and Rollback.
Microsoft Installer Project.
Deploying Outlook Solutions.Review Questions.Migrating VBA Solutions to VSTO.
Topics Covered in This Chapter.
Migration Overview.
Migration Strategies.
Simple Migration of a Word VBA Project.
Advanced Migration of a Word VBA Project.
Copying the Word Template.
Removing the VBA Code and the UserForm from the Template.
Creating a Windows Form.
Starting the Form.
Running the Solution.
Redesigning the Solution.
Bookmark View Controls.
Using the Actions Pane.
VBA and VSTO Interoperability.
Creating an Interop Excel Application.Review Questions.Advanced Topics in VSTO.
Topics Covered in This Chapter.
ServerDocument Overview.
Attaching and Detaching Document-Based Customizations.
Detaching a Solution from a Document Using.
ServerDocument.
Attaching a Solution to a Document Using ServerDocument.
Attaching a Solution to a Document Using Custom Document.
Properties.
Reading and Writing the Data Cache.
Cached Data Structure.
Creating a Test Document with Cached Data.
Reading and Writing the Document Data Cache.
Running the Solution.
Clearing the Data Cache.Review Questions.VSTO 2005 SE and the 2007 Microsoft.
Office System.
Topics Covered in This Chapter.
Introduction to VSTO 2005 SE.
Features in All Releases.
VSTO 2005 SE Add-in Model.
Creating Add-ins.
Creating an Add-in.
Customizing the Ribbon.
The Ribbon Item.
Working with XML.
Customizing the Built-In Ribbon.
Adding Other Controls to the Ribbon.
Quick Access Toolbar.
Unsupported Ribbon Functionality.
Ribbons in Outlook.
Creating Custom Task Panes.
Creating an Add-in for PowerPoint.
Opening and Closing the Custom Task Pane.
Managing Task Panes on Multiple Word Documents.
Converting a Document-Level Customization to a.
VSTO 2005 SE Add-in.
Displaying Multiple Task Panes.
Creating a Custom Form Region.
Creating an Outlook Form Region File.
Creating a New Form Region.
Saving the Form Region.
Creating the VSTO 2005 SE Outlook Add-in Project.
Embedding the Form Region in Your Project.
Creating and Registering the Form Region Manifest.
Creating the Form Region Registration.
Creating a Form Region Startup Class.
Hooking Up Form Region Controls.
Hooking Up the Form Region.
Running the Project.Review Questions.
Appendix A Creating Code Snippets.
Importing the Code Snippet.
Inserting the Code Snippet.
Using the Code Snippets Manager.
Appendix B Creating Inspector CommandBars.