This is the Safari online edition of the printed book.

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

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 32 Ratings

For the professional developer - 2009-05-09
Reviewer Rating:
This is the only book I have found for taking your development skills to the next level after reading all the "how to"-books about Excel VBA. There are a lot of them, some very good. Read them first and practise! Then, if you want to improve your design and make use of your VBA skills to create something really useful for your clients, this book can give you all the inspiration you need.
But it is not the book for you if you are new to Excel VBA.

Continues where other books end - 2009-08-20
Reviewer Rating:
A simple browse of the TOC will show you where this book is heading... A Professional Excel Developer.
Not for the absolute beginner. Intermediates and Advanced Excel'ers will benefit greatly.

A top pick for any computer collection catering to either business managers or Excel programmers - 2009-08-19
Reviewer Rating:
Four top Microsoft Excel developers offer guidance for building secure applications using Excel in the second updated edition of PROFESSIONAL EXCEL DEVELOPMENT, making for a top pick for any Excel library catering to intermediate and advanced Excel programmers. From designing better worksheets and using both built-in and add-on options to using the new Ribbon interface and utilizing XML within Excel, this packs in integrated solutions and is a top pick for any computer collection catering to either business managers or Excel programmers.

This book in it's proper context ... - 2009-08-07
Reviewer Rating:
One of the 4 star reviews mentions that this book only 'overviews' some topics. I thought it's appropriate to mention the reason why this book was written (I read this on Stephen Bullen's website). The Wrox book by Bullen, Green, Bovey has always been the master of advanced VBA, has been since Excel 2000. They did a Excel 2002 edition. But the re-write for Excel 2003 was done without their approval by someone else and was full of bad mistakes. This book came out from the authors under a different publisher, and to me it's the real revision of the Wrox book for Excel 2003, but also it takes Excel development to another level. Hence, it is best treated as an extension to the Wrox book, which incidentally the authors have now regained in the Excel 2007 revision. Buy both.

Worth it's weight in gold - 2009-10-22
Reviewer Rating:
This is the perfect book for those of us who are self-taught VBA developers. This book is especially appropriate for beginning VBA developers. I learned so much from this book that will help me do my job better by writing more solid applications.

I cannot recommend this book enough for anyone who plans on writing Excel applications that need to have a truly professional advantage.

Browse Similar Topics

Top Level Categories:
Programming

Sub-Categories:
Programming > Visual Basic for Applications