Synopses & Reviews
Create Microsoft Office-based applications that work seamlessly in the Microsoft .NET environment—with this essential reference from Microsoft developer Andrew Whitechapel. The author provides expert advice on the various approaches you can use to build managed solutions with Office, and gives practical guidance on the most viable techniques for technical and business scenarios. You’ll begin building custom .NET-based applications with detailed, practical exercises that take you through solutions from beginning to end. Andrew shares tactics, strategies, and best practices—plus full sample code—to help you maximize your development efforts. Packed with the same information used by Microsoft’s Product Support Services team, this book is the one reference that every Office and .NET developer should have.
Discover how to:
- Develop powerful .NET solutions for Office with managed interop assemblies
- Integrate managed code with Microsoft Visual Basic for Applications (VBA)
- Create custom commands and functionality with managed COM and Automation add-ins
- Build custom Office features with external data using Web services, .NET remoting, and research services
- Use Microsoft Visual Studio Tools for Office to create document-centric solutions for Microsoft Excel and Word
- Use digital signatures, strong-naming and .NET Code Access Security
- Control Office applications using Platform Invoke, Reflection, drag-and-drop, and the IAccessible interface
- Develop managed Smart Tags and managed Smart Document solutions
Covers Microsoft Office 97, Office 2000, Office XP, and Microsoft Office System 2003 Editions
Synopsis
- Delivers real-world strategies, tactics, and coding techniques for making Office-based applications work with .NET and for creating custom .NET-based solutions.
- Provides practical guidance on which techniques are viable within various technical and business scenarios.
- Features step-by-step tutorials and sample code available for download.
- This book's information has been vetted by the Microsoft Office Developer team and used by Microsoft's Product Support Services team.
About the Author
Andrew Whitechapel is a senior program manager for the Windows Phone Application Platform team, performing scoping and design for the application platform (both native and managed), including v7.5 (Mango) and future releases. He is responsible for core parts of the platform, including the application packaging/install database and services, the application execution manager, and the resource manager (memory, CPU, thread pool, etc). He has written several books, including the Microsoft Press books Microsoft .NET Development with Microsoft Office and Inside C# (for which he was a co-author), as well as numerous articles for MSDN Magazine and other publications.
Table of Contents
Introduction; How This Book Is Organized; Who This Book Is For; System Requirements and Code Samples; Microsoft Learning Technical Support; Acknowledgments; Chapter 1: Overview; 1.1 Version Variations; 1.2 Notes on the Samples; Chapter 2: Basics of Office Interoperability; 2.1 Managed Interop Assemblies; 2.2 Basic Interop Projects; 2.3 Visual Studio .NET Office Interop Wizards; 2.4 Interface/Class Ambiguity; 2.5 Releasing COM Objects; 2.6 Visual Basic .NET vs. C#; 2.7 Debugging Interop Solutions; Summary; Chapter 3: Office Interop Techniques; 3.1 Platform Invoke; 3.2 Watching Excel Quit; 3.3 Using COM by Reflection; 3.4 Document Properties; 3.5 Connecting to Running Instances; 3.6 Office Accessible Objects; 3.7 Monitoring Office Applications; Summary; Chapter 4: Integrating Managed Code; 4.1 Calling Managed Code from VBA; 4.2 Managed CCW in VBA; 4.3 Managed Office Accelerators; 4.4 Programming the Visual Basic Editor; 4.5 Office and Managed Windows; 4.6 Office Document Browser; 4.7 COM Drag-And-Drop; Summary; Chapter 5: Add-Ins; 5.1 Managed COM Add-Ins; 5.2 Simple Add-In Projects; 5.3 Multiple Host Applications; 5.4 Add-Ins and User Controls; 5.5 Tactical Add-In Issues; 5.6 COM Add-Ins as Cell Functions; 5.7 Excel Automation Add-Ins; Summary; Chapter 6: Smart Tags; 6.1 Managed Smart Tags; 6.2 Smart Tags and the VSTO Loader; 6.3 ISmartTagRecognizer2 and ISmartTagAction2; 6.4 MOSTL Smart Tags; 6.5 A MOSTL Generator; 6.6 Troubleshooting Smart Tags; Summary; Chapter 7: Office Documents and Data; 7.1 Excel and SQL Data; 7.2 Excel and XML; 7.3 Excel and OLE DB; 7.4 Managed Data Feed; 7.5 Real-Time Data in Excel; 7.6 Sinking Office Events; Summary; Chapter 8: Isolating Managed Extensions; AppDomain Isolation; 8.1 The COM Shim Wizard; 8.2 Creating an Add-In Shim; 8.3 Creating a Smart Tag Shim; 8.4 Shim Wizard Internals; 8.5 Config Files; Summary; Chapter 9: Web Services and Remoting; 9.1 The SOAP Toolkit; 9.2 Managed Web Service Proxies; 9.3 WSE Security; 9.4 Research Services; 9.5 Remoting with Office; Summary; Chapter 10: Visual Studio Tools for Office; 10.1 VSTO Code-Behind Assemblies; 10.2 Custom Document Properties; 10.3 Debugging VSTO Solutions; 10.4 Word Code-Behind; 10.5 XML Lists; 10.6 XML Data Form; 10.7 VSTO and Web Services; 10.8 VSTO Configs; Summary; Chapter 11: Smart Documents; 11.1 Smart Documents Core; 11.2 Multiple Target Applications; 11.3 Smart Documents and PIAs; 11.4 Vertigo Managed Smart Documents Wrapper; 11.5 Smart Documents and Smart Tags; 11.6 MOSTL Smart Documents; Summary; Chapter 12: Security; 12.1 Office Macro Security; 12.2 Code Access Security; 12.3 VSTO Security; 12.4 Strong-Naming; 12.5 Authenticode Certificates; 12.6 VSTO Deployment Options; 12.7 Smart Document Security; Summary; Appendix : Andrew Whitechapel;