Download VSTO for Mere Mortals (TM): A VBA Developer's Guide to by Kathleen McGrath PDF

By Kathleen McGrath

Praise for VSTO for Mere Mortals™

"This is the publication I want i would had while i used to be first brought to VSTO and the .NET Framework. it is going to be precious not just to these contemplating VSTO, yet for a person transitioning from place of work VBA to visible Basic.NET. the big variety of topics coated offers an access element for the extra in-depth, developer-oriented documentation to be had on MSDN and elsewhere."

–Cindy Meister, MS be aware MVP

" VSTO for Mere Mortals™ does a very good activity of establishing a bridge among the worlds of VBA and VSTO. Kathleen and Paul express how a VBA developer could have the richness of place of work and in addition the ability, maintainability, and safety of visible Studio. They succeeded in writing a e-book that's approachable, comprehensible, and compelling."

–KD Hallman, normal supervisor, Microsoft, Developer department

"This booklet is a wonderful selection for VBA builders seeking to make the swap to .NET improvement for workplace utilizing visible Studio instruments for workplace. regularly VB.NET code is gifted along similar VBA code to assist illustrate key conceptual and utilization differences."

–Steve Hansen,, writer of getting to know Excel 2003 Programming with VBA and coauthor of getting to know Excel 2000 top class variation

"Visual Studio 2005 instruments for place of work is tips to opt for construction controlled workplace functions. in case you are relocating from VBA to controlled code, this e-book exhibits you the way."

–Ken Getz, Senior advisor, MCW applied sciences, LLC

"This ebook is extremely steered for VBA builders who're drawn to doing place of work programming utilizing the wealthy energy of visible Studio and .NET."

–Mei Liang, software program layout Engineer in try, Microsoft

"Kathleen McGrath has filled VSTO for Mere Mortals™ with in-depth code samples that display VSTO in an easy-to-understand approach. From easy how-to's to complicated performance, it is all right here. I discovered very much from analyzing this book."

–Justin Whitney, Technical Journalist

"This ebook presents an immediately available source for VBA and place of work builders to get to grips with the strong new place of work improvement platform, yet even is going past that, offering a couple of 'worth the acquisition of the e-book' assistance, absolutely sensible examples, and stylish tools from anyone who has evidently spent loads of time with those instruments to aid the mortal at the route to turning into a guru."

–Rory Plaire, options Architect, DigitalCommons LLC

"For the workplace VBA developer attracted to programming in .NET or the .NET programmer seeking to flow to the workplace platform, this e-book is worthy its weight in gold. when you are trying to find a whole, well-written resource to speedy get you up to the mark to enhance and software place of work ideas in visible Studio 2005, i think this ebook is a must-have."

–Frank Rice, Programming author, Microsoft workplace Developer heart

"With this ebook, VBA builders have entry to a good source that would aid them comprehend crucial ideas of controlled code and top practices emigrate VBA suggestions to visible simple 2005 and visible Studio 2005 instruments for place of work. This publication is going past an creation to VSTO to introduce the recent international of VSTO 2005 SE and the 2007 Microsoft workplace system."

–Erika Ehrli Cabral, web site supervisor, MSDN place of work Developer middle, Microsoft

"Kathleen and Paul were concerned with VSTO in a single manner or the opposite from its very beginnings, and it indicates. Their intensity and breadth of information is mirrored during this unique and authoritative ebook. I hugely suggest it for any expert developer making the transition from VBA to controlled code."

–Eric Lippert, software program layout Engineer, Microsoft

VSTO for Mere Mortals™ is for VBA builders who're drawn to migrating their talents to the subsequent new release of place of work improvement. Readers will take advantage of a simple, functional creation to writing controlled code purposes for observe 2003, Excel 2003, and Outlook 2003. Readers also will the right way to create add-ins for the preferred purposes for workplace 2003 and the 2007 Microsoft workplace process utilizing VSTO 2005 SE.

The specialist authors offer a wealth of code samples that blow their own horns renowned beneficial properties of VSTO, equivalent to shrewdpermanent tags and the activities pane. pattern code additionally indicates you the way to customise the recent UI good points of the 2007 Microsoft workplace method, together with the ribbon, customized activity pane, and Outlook types region.

VBA builders will stroll away with

  • A higher figuring out of controlled code and the visible Studio built-in improvement surroundings (IDE)
  • Multiple demonstrations on tips on how to create document-level customizations for notice 2003 and Excel 2003, utilizing view controls, facts binding, and the activities pane
  • A complete evaluate of add-in improvement for Outlook 2003
  • Useful info on securing and deploying options created with VSTO and VSTO 2005 SE
  • A thorough rationalization on how one can migrate VBA options to visible uncomplicated 2005 and VSTO
  • Numerous info on customizing the ribbon, customized job pane, and Outlook shape areas by way of constructing VSTO 2005 SE add-ins for the 2007 Microsoft workplace system

Show description

Read or Download VSTO for Mere Mortals (TM): A VBA Developer's Guide to Microsoft Office Development Using Visual Studio 2005 Tools for Office PDF

Best programming books

How to Do Everything with HTML

One other liberate in our renowned tips on how to Do every thing sequence, this pleasant, solutions-oriented booklet is full of step by step examples for writing HTML code. each one bankruptcy starts with the explicit how-to subject matters that would be lined. in the chapters, every one subject is observed by means of a superb, easy-to-follow walkthrough of the method.

ZooKeeper: Distributed process coordination

Building disbursed functions is tough adequate with no need to coordinate the activities that lead them to paintings. This useful advisor exhibits how Apache ZooKeeper is helping you deal with dispensed structures, so that you can concentration as a rule on program common sense. despite ZooKeeper, imposing coordination projects isn't really trivial, yet this booklet presents solid practices to provide you a head commence, and issues out caveats that builders and directors alike have to look forward to alongside the way.

In 3 separate sections, ZooKeeper individuals Flavio Junqueira and Benjamin Reed introduce the rules of dispensed platforms, offer ZooKeeper programming suggestions, and contain the data you want to administer this service.
• find out how ZooKeeper solves universal coordination projects
• discover the ZooKeeper API’s Java and C implementations and the way they range
• Use ways to tune and react to ZooKeeper kingdom alterations
• deal with mess ups of the community, software procedures, and ZooKeeper itself
• know about ZooKeeper’s trickier elements facing concurrency, ordering, and configuration
• Use the Curator high-level interface for connection administration
• familiarize yourself with ZooKeeper internals and management instruments

iOS 9 Programming Fundamentals with Swift: Swift, Xcode, and Cocoa Basics

Movement into iOS improvement by way of getting an organization take hold of of its basics, together with the Xcode IDE, the Cocoa contact framework, and quick 2. 0—the most recent model of Apple's acclaimed programming language. With this completely up-to-date advisor, you'll study Swift’s object-oriented techniques, know how to exploit Apple's improvement instruments, and notice how Cocoa offers the underlying performance iOS apps have to have.

Microsoft Windows 2000 and IIS 5.0 administrator's pocket consultant

This publication is great while you are operating a server with home windows 2000 and IIS. in case you run into difficulties or have questions while surroundings issues up or preserving them it's a fast reference for solutions.

Extra resources for VSTO for Mere Mortals (TM): A VBA Developer's Guide to Microsoft Office Development Using Visual Studio 2005 Tools for Office

Example text

Com/pstubbs. xxxv This page intentionally left blank Part I Introduction to VSTO This page intentionally left blank 1 Getting Started with VSTO A journey of a thousand miles begins with a single step. —CONFUCIUS Topics Covered in This Chapter What Is VSTO? Why Use VSTO Instead of VBA? Features of VSTO Creating VSTO Solutions How VSTO Integrates with Visual Studio Summary Review Questions What Is VSTO? Visual Studio 2005 Tools for Office (VSTO) enables you to extend Office 2003 applications—such as Word, Excel, InfoPath, and Outlook—using either Visual Basic 2005 or Visual C#.

Data sources can include a database, an Extensible Markup Language (XML) file, or even a text file. Data binding is especially useful for server-side programming. VSTO enables you to store data in the document that is accessible from external applications (without the need to open the document). You do this by storing the data in an XML data island, or data cache. If you store your data in a data cache, you can then access the data cache on the server without having to open the document or install Word or Excel on the server.

Paul’s technical expertise, commitment to completing this project, and sense of humor have been greatly appreciated. —Kathleen McGrath I would like to thank my family for supporting me through the long hours of writing and rewriting, and especially my wife for taking care of everything, enabling me to focus on writing the best book possible. I would also like to thank Kathleen for inviting me write a few chapters for the book. Kathleen has been great to work with and her passion for VSTO is what has made this book possible.

Download PDF sample

Rated 4.16 of 5 – based on 48 votes