Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA (Addison-Wesley Microsoft Technology) Paperback – 1 Feb 2005
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
There is a newer edition of this item:
Frequently Bought Together
Customers Who Bought This Item Also Bought
Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
From the Inside Flap
Unfortunately, Excel is still all too often thought of as a hobbyist platform; that people develop spreadsheet-based applications in their spare time to help out with their day job. A brief look at the shelves of any bookstore seems to confirm that opinion. While there are myriad titles explaining how to use Excel and numerous titles about Excel and VBA, there are none that provide an overall explanation of how to develop professional-quality Excel-based applications. This is that book.
While all the other major languages seem to have a de-facto standard text that explains the commonly-agreed best practices for architecting, designing and developing applications in that language, Excel does not. This book aims to fill that gap.
All three authors are professional Excel developers who run our own companies developing Excel-based applications for clients ranging from individuals to the largest multinational corporations. This book details the approaches we use when designing, developing, distributing and supporting the applications we write for our clients.
This is not a beginner-level book. We assume that the reader will have read and (mostly) understood our Excel 2000/2002 VBA Programmer's Reference, John Walkenbach's Excel N Power Programming or similar titles.
From the Back Cover
Finally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications.
This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's knowledge they've acquired building Excel applications for many of the world's largest companies―including Microsoft. Professional Excel Development demonstrates how to get the utmost from Excel, addressing everything from application architectures through worksheet and userform design, charting, debugging, error handling and optimizing performance. Along the way, the authors offer best practices for every type of Excel development, from building add-ins through interacting with XML Web services. Coverage includes
Building add-ins to provide new Excel functions
Designing effective worksheets, userforms and other user interface elements
Leveraging Excel's powerful data analysis features
Creating sophisticated custom charts
Handling errors, debugging applications and optimizing performance
Using class modules and interfaces to create custom objects
Understanding Windows API calls: when to use them, and how to modify them
Adding worksheet functions with
Programming with databases
Controlling external applications from Excel
Integrating with Visual Basic 6, VB.NET and Visual Studio Tools for Office
Using XML to import and export data and communicate with Web services
Providing help, securing, packaging and distributing
The accompanying CD-ROM contains the book's sample timesheet application at every stage of construction, with detailed code comments. It also includes many examples of the concepts introduced in each chapter and a collection of the authors' Excel development utilities.
© Copyright Pearson Education. All rights reserved.See all Product Description
What Other Items Do Customers Buy After Viewing This Item?
Top Customer Reviews
It's totally different to any other Excel/VBA book available, so comparisons are hard. It doesn't have chapters about the Range or Worksheet objects - the authors seem to expect us to know that already - but instead has topics like choosing architectures, development best practices, optimising performance and rock-solid error handling.
It's a big book so it's hard to pick any bits out
for special mention. Every chapter seems to contain something I'd never seen before, with even the most complex topics (such as custom interfaces, creating XLLs and using XML and web services) explained in a way that made them all easy to understand.
The best bits for me though have to be the practical examples that end most of the chapters. By seeing how the concepts have been applied to their sample application, I can readily see how to apply them to mine, and have already begun to do so.
This is a serious book, not for beginners, and to me it seems to be in a different league to the rest.
Even where a particular topic is familiar to the reader it is bound to include some new tips, any one of which could repay an investment in the book.
It's not for beginners but a must have for anyone who uses Excel extensively. If that's you, and you are wondering if you need it, my best advice is stop thinking about it and get it!
If you arrogantly thought you knew it all in terms of excel's front-end functionality, charting capability, and presentational tools, then this book will bring you back down to earth.
If you are looking for an all-in-one book on the intricacies of API programming, xll, xml and web serivces, a refresher on ADO and SQL, this is it
If you aren't in an environment that fosters best development practice, but craved that discpline to produce effective and efficient code, short of working for Microsoft, this is the book for you.
look no further; this is the book to quench that thirst/hunger you have about Microsoft Excel's immense capabilities, and inject some fun into learning process.
This book has proved to be the perfect manual for someone like me, who just didn't quite have the professional knowledge of how to build a well-designed, robust application from start to finish. After reading just the first few chapters, I'm already much more advanced in understanding the thinking behind the design, why to take which approaches and why not to take other approaches. It really is similar to having an expert sitting beside me and leading me through the steps. Many thanks to the authors for filling this hole in the knowledge market.
The rate at which I learned useful techniques and became aware of "i'd never have found that out myself" gotchas was so rapid I found myself re-reading sections tying to spot the catch. There was none. It really is that easy to learn from this book.
We do not have an official Excel developer employed at my place of work. I have already saved a good deal of man-hours through educating people on the use of Excel. There's scope for much more, now that I'm armed with this book. My pay-rise will be exceptionally healthy!
Most Recent Customer Reviews
This book is very useful if you have a reasonable working knowledge of VBA, that is, more than just recording macros for later editing. Read morePublished on 16 Feb. 2009 by A. V. Hunt
Have just finished reading this book, and it is absolutely superb! Fair enough, it was printed before the days of the 2007 Office/Excel version, however, as I've just discovered,... Read morePublished on 9 Feb. 2009 by Belial
Great book.Learnt a lot about how to develop applications in Excel.Would not recommend it to beginners though.Published on 9 Oct. 2008 by S. Kamineni
Brilliant, just don't buy it until you are reasonably confident with the same authors Excel reference or similar - this is not an entry level text. Read morePublished on 26 Jun. 2008 by Neal G. O'nions
If you are an Excel developer/advanced user and wanting to further your knowledge then this is the book for you. Read morePublished on 24 May 2008 by Whitespaces
I have been building Excel models and using VBA for almost 10 years, and this is by far the best book that I have read about how to build robust VBA applications. Read morePublished on 17 Feb. 2008 by AMK
If you want to use excel as a development platform to produce a sophisticated windows program with no sign that excel is powering it this is the book for you. Read morePublished on 3 Aug. 2006 by Bobby
Stephen enthusiastically takes you through very easy stages of developing a professional, sophisticated application. Read morePublished on 17 Jun. 2006 by G. C. Hannah
Look for similar items by category
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Microsoft Windows > Applications > Excel
- Books > Computing & Internet > Programming > Microsoft Windows
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets