Table of Contents

Visual Studio Tools for Office: Using Visual Basic 2005 with Excel, Word, Outlook, and InfoPath
By Eric Carter, Eric Lippert
...............................................
Publisher: Addison Wesley Professional
Pub Date: April 26, 2006
Print ISBN-10: 0-321-41175-7
Print ISBN-13: 978-0-321-41175-4
Pages: 1120

Table of Contents  | Index

		Copyright
		Praise for Visual Studio Tools for Office
		Microsoft .NET Development Series
		Foreword
		Preface
		Acknowledgments
		About the Authors
		Part I:  An Introduction to VSTO
			Chapter 1.  An Introduction to Office Programming
				Why Office Programming?
				Office Object Models
				Properties, Methods, and Events
				The Office Primary Interop Assemblies (PIAs)
				Conclusion
			Chapter 2.  Introduction to Office Solutions
				The Three Basic Patterns of Office Solutions
				Office Automation Executables
				Office Add-Ins
				Code Behind a Document
				Conclusion
		Part II:  Office Programming in .NET
			Chapter 3.  Programming Excel
				Ways to Customize Excel
				Programming User-Defined Functions
				Introduction to the Excel Object Model
				Conclusion
			Chapter 4.  Working with Excel Events
				Events in the Excel Object Model
				Events in Visual Studio 2005 Tools for Office
				Conclusion
			Chapter 5.  Working with Excel Objects
				Working with the Application Object
				Working with the Workbooks Collection
				Working with the Workbook Object
				Working with the Worksheets, Charts, and Sheets Collections
				Working with Document Properties
				Working with the Windows Collections
				Working with the Window Object
				Working with the Names Collection and Name Object
				Working with the Worksheet Object
				Working with the Range Object
				Special Excel Issues
				Conclusion
			Chapter 6.  Programming Word
				Ways to Customize Word
				Programming Research Services
				Introduction to the Word Object Model
				Conclusion
			Chapter 7.  Working with Word Events
				Events in the Word Object Model
				Events in Visual Studio Tools for Office
				Conclusion
			Chapter 8.  Working with Word Objects
				Working with the Application Object
				Working with the Dialog Object
				Working with Windows
				Working with Templates
				Working with Documents
				Working with a Document
				Working with the Range Object
				Working with Bookmarks
				Working with Tables
				Conclusion
			Chapter 9.  Programming Outlook
				Ways to Customize Outlook
				Custom Property Pages
				Introduction to the Outlook Object Model
				Introduction to the Collaboration Data Objects
				Conclusion
			Chapter 10.  Working with Outlook Events
				Events in the Outlook Object Model
				ApplicationLevel Events
				Outlook Item Events
				Other Events
				Conclusion
			Chapter 11.  Working with Outlook Objects
				Working with the Application Object
				Working with the Explorers and Inspectors Collections
				Working with the Explorer Object
				Working with the Inspector Object
				Working with the NameSpace Object
				Working with the MAPIFolder Object
				Working with the Items Collection
				Properties and Methods Common to Outlook Items
				Outlook Issues
				Conclusion
			Chapter 12.  Introduction to InfoPath
				What Is InfoPath?
				Getting Started
				Form Security
				Programming InfoPath
				Data Source Events
				Form Events, Properties, and Methods
				Conclusion
		Part III:  Office Programming in VSTO
			Chapter 13.  The VSTO Programming Model
				The VSTO Programming Model
				VSTO Extensions to Word and Excel Objects
				Dynamic Controls
				VSTO Extensions to the Word and Excel Object Models
				Conclusion
			Chapter 14.  Using Windows Forms in VSTO
				Introduction
				Adding Windows Forms Controls to Your Document
				Writing Code Behind a Control
				The Windows Forms Control Hosting Architecture
				Properties Merged from OLEObject or OLEControl
				Adding Controls at Runtime
				Conclusion
			Chapter 15.  Working with the Actions Pane
				Introduction to the Actions Pane
				Working with the ActionsPane Control
				Conclusion
			Chapter 16.  Working with Smart Tags in VSTO
				Introduction to Smart Tags
				Creating Document-Level Smart Tags with VSTO
				Creating Application-Level Smart Tags
				Creating an Application-Level Smart Tag Class Library in Visual Studio
				Creating a Recognizer Class
				Creating an Action Class
				Registering and Trusting an Application-Level Smart Tag Class Library
				Running and Testing the Application-Level Smart Tag
				Debugging an Application-Level Smart Tag
				Conclusion
			Chapter 17.  VSTO Data Programming
				Creating a Data-Bound Customized Spreadsheet with VSTO
				Creating a Data-Bound Customized Word Document with VSTO
				Datasets, Adapters, and Sources
				Another Technique for Creating Data-Bound Spreadsheets
				Caching Data in the Data Island
				Advanced ADO.NET Data Binding: Looking Behind the Scenes
				Binding-Related Extensions to Host Items and Host Controls
				Conclusion
			Chapter 18.  Server Data Scenarios
				Populating a Document with Data on the Server
				Using ServerDocument and ASP.NET
				An Alternative Approach: Create a Custom Handler
				A Handy Client-Side ServerDocument Utility
				The ServerDocument Object Model
				Conclusion
			Chapter 19.  .NET Code Security
				Code-Access Security Versus Role-Based Security
				Code-Access Security in .NET
				Publisher Certificates
				Trusting the Document
				Conclusion
			Chapter 20.  Deployment
				VSTO Prerequisites
				Deploying to an Intranet Shared Directory or Web Site
				Local Machine Deployment Without a Deployment Manifest
				Editing Manifests
				Creating Setup Packages
				Conclusion
		Part IV:  Advanced Office Programming
			Chapter 21.  Working with XML in Excel
				Introduction to Excel's XML Features
				Introduction to XML Schema Creation in Visual Studio
				An End-to-End Scenario
				Advanced XML Features in Excel
				Excel-Friendly XML Schemas
				VSTO Support for Excel Schema Mapping
				Conclusion
			Chapter 22.  Working with XML in Word
				Introduction to Word's XML Features
				An End-to-End Scenario: Creating a Schema and Mapping It into a Word Document
				Exporting the Mapped XML in the Document to an XML Data File
				Importing an XML Data File into the Mapped Document
				The XML Options Dialog Box
				VSTO Support for Word Schema Mapping
				VSTO Support for the WordML File Format
				Conclusion
			Chapter 23.  Developing COM AddIns for Word and Excel
				Introduction to AddIns
				Scenarios for Using AddIns
				How a COM AddIn Is Registered
				Implementing IDTExtensibility2
				Writing a COM AddIn Using Visual Studio
				The Pitfalls of mscoree.dll
				COM Interop and regasm.exe
				Shimming: A Solution to the Problems with mscoree.dll
				Conclusion
			Chapter 24.  Creating Outlook AddIns with VSTO
				Moving Away from COM AddIns
				Creating an Outlook AddIn in VSTO
				Conclusion
		Bibsrc Bibliography
			Security
			Office Programming
			Data Programming
			Forms Programming
			Infrastructure
		Index