VBA and Macros for Microsoft Excel

This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version.

The Start-to-Finish Guide to Building State-of-the-Art Solutions with Excel 2007

In this book, four world-class Microsoft® Excel developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors—three of whom have been honored by Microsoft as Excel Most Valuable Professionals (MVPs)—show how to consistently make the right design decisions and make the most of Excel’s most powerful new features. Using their techniques,you can reduce development costs, time to market, and hassle—and build more effective, successful solutions.

Fully updated for Excel 2007, this book starts where other books on Excel programming leave off. Through a hands-on case study project, you’ll discover best practices for planning, architecting, and building Excel applications that are robust, secure, easy to maintain, and highly usable. If you’re a working developer, no other book on Excel programming offers you this much depth, insight, or value.

•    Design worksheets that will be more useful and reliable

•    Leverage built-in and application-specific add-ins

•    Construct applications that behave like independent Windows programs

•    Make the most of the new Ribbon user interface

•    Create cross-version applications that work with legacy versions of Excel

•    Utilize XML within Excel applications

•    Understand and use Windows API calls

•    Master VBA error handling, debugging, and performance optimization

•    Develop applications based on data stored in Access, SQL Server, and other databases

•    Build powerful visualization solutions with Excel charting engine

•    Learn how to work with VB.NET and leverage its IDE

•    Automate Microsoft Excel with VB.NET

•    Create managed COM add-ins for Microsoft Excel with VB.NET

•    Develop Excel solutions with Visual Studio Tools for Office (VSTO)

•    Integrate Excel with Web Services

•    Deploy applications more securely and efficiently

This is the eBook version of the printed book.

Learn the ins and outs of Mail Merge in Word 2007, including how to select and prepare a data file and a main document, how to manually or automatically set up field codes, and how to print, save, and manage merged letters, envelopes, labels, and catalogs.

Contents:

What Is a Mail Merge?

Performing a Letter Merge with the Mail Merge Wizard

Selecting a Main Document Type

Selecting a Data Source

Preparing the Main Document

Inserting Merge Fields

Filtering and Sorting the Data

Previewing and Printing the Merge

Creating Custom Merges with Word Fields

Faithe Wempen, M.A., is a Microsoft Office Master Instructor and an adjunct instructor of computer information technology at Indiana University/Purdue University at Indianapolis, specializing in Microsoft Office and PC hardware. She is the author of more than 90 books on PC hardware and software and teaches online courses in Office applications for corporate clients including Hewlett-Packard, Gateway, and Sony. She also owns and operates Sycamore Knoll Bed and Breakfast (www.sycamoreknoll.com).

Pivot Tables are the MOST powerful feature in Excel and this book offers a comprehensive review of their functionality.

• Over 30 years combined experience, Bill Jelen and Michael Alexander's experience is difficult to replicate in any other team
• Provides practical, real-world scenarios that not only demonstrate the benefits of Pivot Tables, but also explains how to avoid pitfalls of every day data crunching
• Includes proven and creative Pivot Table recipes for fast results on the job