The Pitfalls of MsCoree.dll
The Visual Studio setup project created when you create a COM add-in using the Shared Add-In Wizard provides a setup package that you can use to deploy your COM add-in to your customers' machines. At first glance, the setup created by Visual Studio appears to cover all the deployment requirements for COM add-ins, but alas life is not quite that easy. A deployed COM add-in written in managed code really needs to be "shimmed." To understand what a shim is and why it is needed, we have to dig into how a COM add-in written in managed code is actually loaded into an Office application.
Part One. An Introduction to VSTO
An Introduction to Office Programming
- Why Office Programming?
- Office Object Models
- Properties, Methods, and Events
- The Office Primary Interop Assemblies (PIAs)
- Conclusion
Introduction to Office Solutions
- The Three Basic Patterns of Office Solutions
- Office Automation Executables
- Office Add-Ins
- Code Behind a Document
- Conclusion
Part Two. Office Programming in .NET
Programming Excel
- Ways to Customize Excel
- Programming User-Defined Functions
- Introduction to the Excel Object Model
- Conclusion
Working with Excel Events
Working with Excel Objects
- 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
Programming Word
Working with Word Events
Working with Word Objects
- 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
Programming Outlook
- Ways to Customize Outlook
- Introduction to the Outlook Object Model
- Introduction to the Collaboration Data Objects
- Conclusion
Working with Outlook Events
Working with Outlook Objects
- 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
Introduction to InfoPath
- What Is InfoPath?
- Getting Started
- Form Security
- Programming InfoPath
- Data Source Events
- Form Events, Properties, and Methods
- Conclusion
Part Three. Office Programming in VSTO
The VSTO Programming Model
- The VSTO Programming Model
- VSTO Extensions to Word and Excel Objects
- Dynamic Controls
- Advanced Topic: Dynamic Host Items
- Advanced Topic: Inspecting the Generated Code
- VSTO Extensions to the Word and Excel Object Models
- Conclusion
Using Windows Forms in VSTO
- 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
Working with Actions Pane
Working with Smart Tags in VSTO
- Introduction to Smart Tags
- Creating Document-Level Smart Tags with VSTO
- Creating Application-Level Smart Tags
- Conclusion
VSTO Data Programming
- 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
Server Data Scenarios
- Populating a Document with Data on the Server
- Using ServerDocument and ASP.NET
- A Handy Client-Side ServerDocument Utility
- The ServerDocument Object Model
- Conclusion
.NET Code Security
- .NET Code Security
- Code Access Security Versus Role-Based Security
- Code Access Security in .NET
- Location, Location, Location
- Strong Names
- Publisher Certificates
- Trusting the Document
- Deploying Policy to User Machines
- Conclusion
Deployment
- Deployment
- VSTO Prerequisites
- Deploying to an Intranet Shared Directory or Web Site
- Local Machine Deployment Without a Deployment Manifest
- Editing Manifests
- Creating Setup Packages
- Advanced Topic: Deploying Network Solutions to Be Cached Locally
- Conclusion
Part Four. Advanced Office Programming
Working with XML in Excel
- Introduction to Excels 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
Working with XML in Word
- Introduction to Words 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
- VSTO Support for Word Schema Mapping
- VSTO Support for the WordML File Format
- Conclusion
Developing COM Add-Ins for Word and Excel
- Introduction to Add-Ins
- Scenarios for Using Add-Ins
- How a COM Add-In Is Registered
- Implementing IDTExtensibility2
- Writing a COM Add-In Using Visual Studio
- The Pitfalls of MsCoree.dll
- COM Interop and Regasm.exe
- Shimming: A Solution to the Problems with MsCoree.dll
- Conclusion
Creating Outlook Add-Ins with VSTO
EAN: N/A
Pages: 214
- ERP System Acquisition: A Process Model and Results From an Austrian Survey
- Distributed Data Warehouse for Geo-spatial Services
- Data Mining for Business Process Reengineering
- Relevance and Micro-Relevance for the Professional as Determinants of IT-Diffusion and IT-Use in Healthcare
- Development of Interactive Web Sites to Enhance Police/Community Relations
