Dotnetcat » .NET Books » Office books

Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook is the definitive book on VSTO 2008 programming, written by the inventors of the technology. VSTO is a set of tools that allows professional developers to use the full power of Microsoft Visual Studio 2008 and the .NET Framework to program against Microsoft Office 2007.

This book delivers in one place all the information you need to succeed using VSTO to program against Word 2007, Excel 2007, and Outlook 2007, and provides the necessary background to customize Visio 2007, Publisher 2007, and PowerPoint 2007. It introduces the Office 2007 object models, covers the most commonly used objects in those object models, and will help you avoid the pitfalls caused by the COM origins of the Office object models. Developers who wish to program against Office 2003 should consult Carter and Lippert’s previous book, Visual Studio Tools for Office.

In VSTO 2008, you can build add-ins for all the major Office 2007 applications, build application-level custom task panes, customize the new Office Ribbon, modify Outlook’s user interface using Form Regions, and easily deploy everything you build using ClickOnce.

Carter and Lippert cover their subject matter with deft insight into the needs of .NET developers learning VSTO, based on the deep knowledge that comes from the authors’ unique perspective of living and breathing VSTO for the past six years. This book

• Explains the architecture of Microsoft Office programming and introduces the object models
• Covers the main ways Office applications are customized and extended
• Explores the ways of customizing Excel, Word, and Outlook, and plumbs the depths of programming with their events and
  object models
• Introduces the VSTO programming model
• Teaches how to use Windows Forms and WPF in VSTO and how to work with the Document Actions Pane and application-level task panes
• Delves into VSTO data programming and server data scenarios
• Teaches ClickOnce VSTO deployment

This is the one book you need to succeed in programming against Office 2007.

C# and Visual Basic .NET Code samples for download can be found here: http://www.informit.com/store/product.aspx?isbn=0321533216

Want to know how to do everything? This solutions-oriented resource will show you how to get the most out of all the features Outlook has to offer. Manage your personal information, use all the e-mail functions, keep your calendar current, and find out how to make all the new capabilities work for you.

Explore InfoPath 2003—and transform the way you manage business information and deliver results! This guide expertly reviews InfoPath features and capabilities—including the latest updates from Microsoft Office Service Pack 1—demonstrating how to create easy-to-use forms to capture data from spreadsheets, text files, databases, XML Web Services, and even e-mail in reusable XML format. Whether you’re streamlining your invoicing system, managing performance appraisals, or collecting feedback from users or customers, you’ll discover how to quickly connect the people and information you need—with no XML expertise or advanced programming required.Covers Microsoft Office 2003 Service Pack 1!

Discover how to:

• Use InfoPath forms to capture and validate user input—without writing code
• Design form features, from basic controls and views to digital signing options
• Send forms to shared servers, websites, form libraries, or e-mail
• Easily reuse captured XML data in other applications, such as Microsoft Word or Excel
• Develop front-end forms that interoperate with back-end databases such as Microsoft SQL Server and with Web Services
• Use your programming skills to customize forms with the InfoPath 2003 Toolkit for Visual Studio .NET
• Generate special purpose XML documents, such as Really Simple Syndication (RSS) 2.0 filesGet ready-to-use InfoPath forms on CD!

CD features:

• Sample InfoPath business forms to adapt for your own use
• Files for all the book’s examples
• Fully searchable electronic version of the book

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.

Master the How and Why of Office 2003! Students master the "How and Why" of performing tasks in Office and gain a greater understanding of how to use the individual applications together to solve business problems.

By using the same back-end macro programming language, Visual Basic for Applications (VBA), Microsoft Office applications allow users to easily transfer their VBA programming skills from one Office product to another. A developer who is skilled at using VBA to program Access can quickly learn to program Word or Excel. Better still, VBA is a fairly complete subset of Visual Basic (VB). That means a Visual Basic developer already knows how to use VBA and a VBA programmer knows a lot about Visual Basic. In addition to this large body of shared information, learning to program Office applications requires that the developer understand each application's specific features. For example, to write VBA code for Microsoft Word, the developer must understand Word's capabilities and how to make Word do useful things. Unfortunately most VB and VBA books assume the reader is learning to program from scratch. They ignore the large amount of VBA programming information that is shared by the applications and they teach all of the details starting with the basics. A programmer who wants to learn how to program several Office applications must buy separate books for each application with a huge amount of overlap. Microsoft Office Programming: A Guide for Experienced Developers covers only the material not shared by all of the Office applications. It focuses on the more advanced techniques that start where the other books' VBA tutorials end. It explains how to link the applications together using OLE, how to manipulate each application with VBA code, and how to make the applications work together by controlling each other.

A must-have guide that covers all the new features of Visual Studio 2010

Visual Studio allows you to create and manage programming projects for the Windows platform, and the new 2010 version has undergone a major overhaul comprised of significant changes. Written by an author team of veteran programmers and developers, Professional Visual Studio 2010 gets you quickly up to speed on what you can expect from the newest version of Visual Studio.

This book's first section is dedicated to familiarizing you with the core aspects of Visual Studio 2010. Everything you need is contained in the first five chapters, from the IDE structure and layout to the various options and settings you can change to make the user interface synchronize with your own way of doing things.

From there, the remainder of the book is broken into 11 parts:

• Getting Started: In this part, you learn how to take control of your projects and organize them in ways that work with your own style.
• Digging Deeper: Though the many graphical components of Visual Studio that make a programmer's job easier are discussed in many places throughout this book, you often need help when you're in the process of actually writing code. This part deals with features that support the coding of applications such as IntelliSense, code refactoring, and creating and running unit tests In the latest version of the .NET framework, enhancements were added to support dynamic languages and move towards feature parity between the two primary .NET languages, C# and VB. This part covers changes to these languages, as well as looking at a range of features that will help you write better and more consistent code.
• Rich Client and Web Applications: For support building everything from Office add-ins to cloud applications, Visual Studio enables you to develop applications for a wide range of platforms. These two parts cover the application platforms that are supported within Visual Studio 2010, including ASP.NET and Office, WPF, Silverlight 2 and ASP.NET MVC.
• Data: A large proportion of applications use some form of data storage. Visual Studio 2010 and the .NET Framework include strong support for working with databases and other data sources. This part examines how to use DataSets, the Visual Database Tools, LINQ, Synchronization Services and ADO.NET Entity Framework to build applications that work with data. It also shows you how you can then present this data using Reporting.
• Application Services: Through the course of building an application you are likely to require access to services that may or may not reside within your organization. This part covers core technologies such as WCF, WF, Synchronization Services and WCF RIA services that you can use to connect to these services.
• Configuration and Internationalization: The built-in support for configuration files allows you to adjust the way an application functions on the fly without having to rebuild it. Furthermore, resource files can be used to both access static data and easily localize an application into foreign languages and cultures. This part of the book shows how to use .NET configuration and resource files.
• Debugging: Application debugging is one of the more challenging tasks developers have to tackle, but correct use of the Visual Studio 2010 debugging features will help you analyze the state of the application and determine the cause of any bugs. This part examines the rich debugging support provided by the IDE.
• Build and Deployment: In addition to discussing how to build your solutions effectively and getting applications into the hands of your end users, this part also deals with the process of upgrading your projects from previous versions.
• Customizing and Extending Visual Studio: If the functionality found in the previous part isn't enough to help you in your coding efforts, Microsoft has made Visual Studio 2010 even more extensible. This part covers the automation model, how to write add-ins and macros, and then how to use a new extensibility framework, MEF, to extend Visual Studio 2010.
• Visual Studio Ultimate: The final part of the book examines the additional features only available in the Premium and Ultimate versions of Visual Studio 2010. In addition, you'll also learn how the Team Foundation Server provides an essential tool for managing software projects.

Though this breakdown of the Visual Studio feature set provides the most logical and easily understood set of topics, you may need to look for specific functions that will aid you in a particular activity. To address this need, references to appropriate chapters are provided whenever a feature is covered in more detail elsewhere in the book.

Professional Visual Studio 2010 is for all developers new to Visual Studio as well as those programmers who have some experience but want to learn about features they may have previously overlooked.

If you are familiar with the way previous versions of Visual Studio worked, you may want to skim over Part I, which deals with the basic constructs that make up the user interface, and move on to the remainder of the book where the new features found in Visual Studio 2010 are discussed in detail. While you may be familiar with most of Part I, it is worth reading this section in case there are features of Visual Studio 2010 that you haven't seen or used before.

If you're just starting out, you'll greatly benefit from the first part, where basic concepts are explained and you're introduced to the user interface and how to customize it to suit your own style.

MICROSOFT OFFICE EXCEL 2010: COMPLETE provides a project-based, step-by-step approach to successfully teach students Microsoft Excel 2010 skills.

Get the comprehensive reference for extending Microsoft Office Outlook 2007. Many knowledge workers rely on Office Outlook to help them structure their days managing e-mail messages, calendars, contacts, and tasks. Now, with new extensibility features in Office Outlook 2007, developers can create add-ins that allow data from other tools and applications to be hosted within Outlook 2007. By gathering more information together in one application and one so familiar users can experience increased levels of productivity. This complete guide shows developers how to exploit the new features in Office Outlook 2007 to extend, adapt, and customize information flow to the desktop. Includes code samples in Microsoft Visual Basic® and Microsoft Visual C#®.

Delivers authoritative platform guidance to inform developers when add-in and form customizations are appropriate

Provides add-in templates and extensive code samples in Visual Basic and Visual C# (with additional information about Visual C++)

Features end-to-end sample applications

Finally, a book comes a long that is the definitive reference on the Microsoft Office Web Components. Learn how to build windows forms and web based applications containing interactive Microsoft Excel spreadsheets, customized pivot tables and dynamic 2D/3D charts and graphs. Inside, you will find hundreds of code snippets in C#, VB.NET, Javascript, and VBscript, complete walkthrus, sample implementations and advanced coding strategies and techniques for building commercial-grade software that will integrate seamlessly with core Microsoft Office products. With nearly 570 pages, this book offers something for every level of developer.

A comprehensive guide to programming for Access 2010 and 2007

Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements.

With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic.

Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications.

Coverage Includes:

• Introduction to Microsoft Access 2010
• New Features
• Upgrading and Converting to Access 2010
• Macros in Access 2010
• Using the VBA Editor
• VBA Basics
• Using VBA in Access
• Creating Classes in VBA
• Extending VBA with APIs
• Working with the Windows Registry
• Using DAO to Access Data
• Using ADO to Access Data
• Using SQL with VBA
• Using VBA to Enhance Forms
• Enhancing Reports with VBA
• Customizing the Ribbon
• Customizing the Office Backstage
• Working with Office 2010
• Working with SharePoint
• Working with .NET
• Building Client-Server Applications with Access
• The Access 2010 Templates
• Access Runtime Deployment
• Database Security
• Access 2010 Security Features