Visual Studio Tools for Office(c) Using Visual Basic 2005 with Excel, Word, Outlook, and InfoPath

Visual Studio Tools for Office: Using Visual Basic 2005 with Excel, Word, Outlook, and InfoPath

ISBN: 0321411757
EAN: 2147483647

Year: N/A
Pages: 221

Authors: Eric Carter, Eric Lippert

BUY ON AMAZON

Visual Studio Tools for Office: Using Visual Basic 2005 with Excel, Word, Outlook, and InfoPath
Table of Contents
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
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z