Microsoft Excel is much more than just a spreadsheet. With the introduction
of the Visual Basic Editor in Excel 97, followed by the significantly
improved stability of Excel 2000, Excel became a respected development
platform in its own right. Excel applications are now found alongside those
based on C++, Java, and the .NET development platform, as part of the
core suite of mission-critical corporate applications.
Unfortunately, Excel is still too often thought of as a hobbyist platform,
that people only develop Excel applications in their spare time to automate
minor tasks. A brief look at many Excel VBA books seems to confirm this
opinion. These books focus on the basics of automating Excel tasks using
VBA. This book is the first of its kind in providing a detailed explanation
of how to use Excel as the platform for developing professional quality
applications.
While most other major development platforms seem to have a de
facto standard text that explains the commonly agreed best practices for
architecting, designing, and developing applications using that platform,
until now Excel has not. This book attempts to fill that gap. The authors are
professional Excel developers who create Excel-based applications for
clients ranging from individuals to the largest multinational corporations.
This book explains the approaches we use when designing, developing, distributing,
and supporting the applications we write for our clients.