Visual Studio 2005 Tools for Office for Mere Mortals
Home > Computing and Information Technology > Computer programming / software engineering > Programming and scripting languages: general > Visual Studio 2005 Tools for Office for Mere Mortals: A VBA Developer's Guide to Managed Code in Microsoft Office
4%
Visual Studio 2005 Tools for Office for Mere Mortals: A VBA Developer's Guide to Managed Code in Microsoft Office

Visual Studio 2005 Tools for Office for Mere Mortals: A VBA Developer's Guide to Managed Code in Microsoft Office

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

VSTO for Mere Mortals™ is for VBA developers who are interested in migrating their skills to the next generation of Office development. Readers will benefit from a straightforward, practical introduction to writing managed code applications for Word 2003, Excel 2003, and Outlook 2003. Readers will also learn how to create add-ins for the most popular applications for Office 2003 and the 2007 Microsoft Office system using VSTO 2005 SE. The expert authors provide a wealth of code samples that show off popular features of VSTO, such as smart tags and the actions pane. Sample code also shows you how to customize the new UI features of the 2007 Microsoft Office system, including the ribbon, custom task pane, and Outlook forms region.   VBA developers will walk away with A greater understanding of managed code and the Visual Studio integrated development environment (IDE) Multiple demonstrations on how to create document-level customizations for Word 2003 and Excel 2003, using view controls, data binding, and the actions pane A comprehensive overview of add-in development for Outlook 2003 Useful information on securing and deploying solutions created with VSTO and VSTO 2005 SE A thorough explanation on how to migrate VBA solutions to Visual Basic 2005 and VSTO Numerous details on customizing the ribbon, custom task pane, and Outlook form regions by developing VSTO 2005 SE add-ins for the 2007 Microsoft Office system

Table of Contents:
Foreword xxi Preface xxv Introduction xxvii Acknowledgments xxxiii About the Authors xxxv Part I Introduction to VSTO 1 Chapter 1 Getting Started with VSTO 3 Topics Covered in This Chapter 3 What Is VSTO? 3 Why Use VSTO Instead of VBA? 5 Features of VSTO 7 Creating VSTO Solutions 15 How VSTO Integrates with Visual Studio 22 Summary 25 Review Questions 26 Chapter 2 The Programming Environment 27 Topics Covered in This Chapter 27 Introduction to the Visual Studio IDE 27 Viewing IDE Windows 35 Tools for Writing Code 52 Building and Running Code 61 Debugging Your Code 63 Locating and Using Help 82 Summary 87 Review Questions 88 Chapter 3 Introduction to Managed Code 89 Topics Covered in This Chapter 89 What Is Managed Code? 89 Introduction to Object-Oriented Programming 91 Exploring the .NET Framework 108 VSTO and Managed Code 120 Summary 126 Review Questions 127 Chapter 4 Moving from VBA to VSTO and Visual Basic 2005 129 Topics Covered in This Chapter 129 Moving to Visual Basic 2005 129 New Features of Visual Basic 2005 130 Language Differences of VBA and Visual Basic 2005 140 UserForms Versus Windows Forms 152 Summary 170 Review Questions 170 Part II Word and Excel 171 Chapter 5 Customizing Word and Excel Task Panes 173 Topics Covered in This Chapter 173 What Is a Task Pane? 173 Customizing the Document Actions Task Pane 175 Managing the Actions Pane 177 Designing Actions Pane Solutions 180 Creating Context-Sensitive Solutions 194 Summary 204 Review Questions 205 Chapter 6 Customizing Word with VSTO 207 Topics Covered in This Chapter 207 Programming in Word 207 Word Host Items and Host Controls 218 Data Binding to Host Controls on Documents 233 Programming Against Events 240 Special Enhancements to the Bookmark 265 Making Word Documents Smart 269 Summary 270 Review Questions 271 Chapter 7 Customizing Excel with VSTO 273 Topics Covered in This Chapter 273 Programming in Excel 273 Excel Host Items and Host Controls 285 Data Binding to Host Controls on Worksheets 308 Programming Against Events 320 Making Excel Smarter 348 Summary 349 Review Questions 350 Chapter 8 Controls in Word and Excel 351 Topics Covered in This Chapter 351 About Controls 351 Adding Controls to Toolbars and Menus 352 Using Windows Forms Controls 365 Adding Controls to a Windows Form 378 Adding Controls to the Task Pane 388 Adding Controls to Excel and Word Documents 390 Summary 415 Review Questions 416 Chapter 9 Smart Tags in Word and Excel 417 Topics Covered in This Chapter 417 What Is a Smart Tag? 417 Creating Word and Excel Smart Tags with VSTO 422 Understanding Smart Tag Properties 426 Taking Action on a Smart Tag 428 Introduction to Regular Expressions 436 Overriding Smart Tag Recognizers 446 Summary 455 Review Questions 455 Part III Outlook and Beyond 457 Chapter 10 Creating Add-ins for Outlook with VSTO 459 Topics Covered in This Chapter 459 Application-Level Customizations Using VSTO 459 Outlook Object Model Overview 475 Customizing Menus and Toolbars in Outlook 482 Debugging Add-ins 486 Security in Outlook Add-ins Created with VSTO 492 Summary 496 Review Questions 497 Chapter 11 Security and Deployment 499 Topics Covered in This Chapter 499 VSTO Security Model 499 Deploying Word and Excel Solutions 505 Deploying Outlook Solutions 528 Summary 529 Review Questions 529 Chapter 12 Migrating VBA Solutions to VSTO 531 Topics Covered in This Chapter 531 Migration Overview 531 Migration Strategies 532 Simple Migration of a Word VBA Project 534 Advanced Migration of a Word VBA Project 537 VBA and VSTO Interoperability 547 Summary 553 Review Questions 553 Chapter 13 Advanced Topics in VSTO 555 Topics Covered in This Chapter 555 ServerDocument Overview 555 Attaching and Detaching Document-Based Customizations 556 Reading and Writing the Data Cache 560 Clearing the Data Cache 571 Summary 572 Review Questions 572 Chapter 14 VSTO 2005 SE and the 2007 Microsoft Office System 575 Topics Covered in This Chapter 575 Introduction to VSTO 2005 SE 575 Creating Add-ins 584 Customizing the Ribbon 585 Creating Custom Task Panes 622 Creating a Custom Form Region 638 Summary 650 Review Questions 650 Appendix A Creating Code Snippets 651 Appendix B Creating Inspector CommandBars 657 Index 665


Best Sellers


Product Details
  • ISBN-13: 9780132701716
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Addison Wesley
  • Language: English
  • Returnable: N
  • ISBN-10: 0132701715
  • Publisher Date: 29 Dec 2006
  • Binding: Digital download
  • No of Pages: 512
  • Sub Title: A VBA Developer's Guide to Managed Code in Microsoft Office


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Visual Studio 2005 Tools for Office for Mere Mortals: A VBA Developer's Guide to Managed Code in Microsoft Office
Pearson Education (US) -
Visual Studio 2005 Tools for Office for Mere Mortals: A VBA Developer's Guide to Managed Code in Microsoft Office
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Visual Studio 2005 Tools for Office for Mere Mortals: A VBA Developer's Guide to Managed Code in Microsoft Office

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!