|
| Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (Addison-Wesley Microsoft Technology Series) | 
| Authors: Stephen Bullen, Rob Bovey, John Green
Publisher: Addison-Wesley Professional
Category: Book
List Price: $64.99
Buy New: $19.00
You Save: $45.99 (71%)
New (34) from $19.00
Avg. Customer Rating:  26 reviews
Sales Rank: 124880
Media: Paperback
Number Of Items: 1
Pages: 936
Shipping Weight (lbs): 2.9
Dimensions (in): 8.9 x 6.7 x 1.7
ISBN: 0321262506
Dewey Decimal Number: 005.54
EAN: 9780321262509
ASIN: 0321262506
Publication Date: February 11, 2005
Availability: Usually ships in 1-2 business days
Condition: NEW! Cover may have some minor shelf wear. 90% of all orders ship within 24 hours. All orders ship in secure bubble packs. Free tracking on all domestic orders. Your satisfaction is guaranteed!
|
| Customer Reviews:
Excellent Tool for Programmers ! November 3, 2006
3 out of 3 found this review helpful
In spite of being an advanced book, difficult concepts are explained clearly and in a very simple way.
You can find a lot of advices on best practices throughout the book as well as very powerful techniques that are really useful while you develop your applications.
For an advanced VBA programmer, this book is a must.
Best Excel development book to date April 26, 2006
14 out of 15 found this review helpful
The depth of Excel development knowledge of the authors can be readily seen a few pages into the Introduction. If you have been frequent visitors to Excel/VBA programming newsgroups like myself, you will notice immediately that all three authors are well-recognized experts in this domain, and have answered countless tricky questions on the topic of Excel/VBA. In my opinion, the particularly valuable chapters include:
- Chapter 3 on "Best Practices"
- Chapter 17 on "Optimizing VBA Performance"
- Chapter 19 on "XLLs/C API"
- Chapters 20-21 on VB6
- Chapter 22 on VB.NET/VSTO
This is such a comprehensive book that will transform your Excel development skills to the professional level. Without reservation, the authors have delivered what the book title promises.
Looking to take your Excel to the next level? BUY THIS BOOK!!!! March 10, 2006
23 out of 23 found this review helpful
I've been working with Excel for years...
This is by far the BEST EXCEL DEVELOPMENT BOOK I've ever seen. It paid for itself many, many times over in the theory, and code tricks I've learned from it.
BEWARE BEGINNERS....if you're unfamiliar with Excel or VBA development, this isn't the book for you...start with Excel 2003 Power Programming by John Walkenbach.
If you're looking to take your spreadsheets to the next level, BUY THIS BOOK...IT RULES
Goes Beyond my Expectations March 3, 2006
5 out of 8 found this review helpful
This book is a fantastic edition to any programmer's skillset.
These guys prove that Excel is not just a toy programming platform.
Wisdom Packed into Every Page! Brilliantly Written January 12, 2006
45 out of 46 found this review helpful
Even if this book was not as well-written and insightful as it is, there is simply no other VBA book that comes close, in content and quality, on building professional-grade Excel applications. If that is your field, you have a lot to lose by not getting it. (I've stalked several large bookstores here in New York City and Amazon, of course.)
THE BOOK:
This book is a goldmine of application-design wisdom for developers seeking to write professional, VBA applications that stand the test of time. Even for none-professionals, like myself, the book contains a plethora of VBA "best practices" that can be put to immediate use. The authors are clearly sharing with you years of personal, professional experience, and top-notch acumen.
Because I am not the most attentive reader, the first thing I find myself looking at is how well-written a book is (a quality which makes me a Walkenbach fan). I am impressed by how "thorough", "well put", and "to the point" most sentences in this book are - from the first to last word!
A FEW HIGHLIGHTS FOR ME:
> Imagine building almost bullet-proof applications. The user never sees an ugly VBA error message, and, if an error occurs, the developer usually knows very quickly what the cause is. I do this now...courtesy of the book's excellent chapter 12 on Error Handling and a thorough chapter on Debugging (Chapter 16).
> Chapter 17 - Optimizing VBA Performance (and a little digression on creative thinking) is a must read. This alone is worth the book price!
> Imagine a progress-bar display that you can easily "plug in" to any VBA program you write. Now you can...this book shows you how, in Chapter 11.
> Do you understand how to use API functions, and which ones are most useful for Excel. Read Chapter 9. I first found this chapter online (informit.com), which led me to this book, in the first place. Knowing API, will allow you to tap into the entire windows operating system from VBA.
> Do you really understand classes...do you understand Interfaces and how you can put them to use in VBA?
Chapter 7 on Classes is worth a solid read. (Even if you've read chapter 5 & 6, in Ken Getz's VBA Developer's handbook). Chapter 11, demonstrates the usefulness of Interfaces, with two great examples (Sorting and Progress-Display).
> What if you wish to write code in .Net, C, (or VB6) yet still work with EXCEL or connect with your VBA code? This book shines on this topic with three chapters (20 - 22). I have not yet seen a discussion as thorough in another VBA book. (If I've missed one, please add me to your Amazon buddy list and email me. Thanks.)
> If you are not a database expert but want a good overview of using Excel to work with Databases, I suggest your read Chapter 13.
> How do "you" currently go about building your Application's Menubars and ToolBars? Most books recommend a table-driven system of some sort or another, which is what I was using, and, indeed, this book does, too...but wait until you see the authors' version in Chapter 8. In fact, I made the painful decision to give up my habit of doing things after spending time with this chapter, and the authors' wisdom is paying off!
As a reviewer from California put it, "Finally, The sequel to Walkenbach for developers is here!", and another from New Delhi, "Every line that I have read so far has a meaning. The book is written in a simple fluent language and brings out the point very clearly. It will take me to the next level of programming."
I could not agree more!
ACCESSORIES:
As you would expect, all code examples for the book (and more) are found on an accompanying CD. The excellent commenting of code, aids learning.
I do have one peeve: The book is not available in searchable PDF format. To be fair to the authors...if they did...your grandmother would probably have it by now ;-) (For a fee you can download chapters in html from http://safari.oreilly.com/)
I also use two, must-have, VBA Add-Ins produced by Stephen Bullen and Rob Bovey respectively, free of charge from their respective websites.
Stephen Bullen's Auto-Indenter: with a simple "right click", your VBA code is automatically indented at all the right places (with options to suit your personal preferences). Think of how much time you spend tabbing and moving lines about!
Rob Bovey's code-cleaner: which cleans up your VBA file and shrinks its size significantly. (It also gets rid of a mysterious VBA error, the name of which escapes me now).
|
|
|
Wildlife, nature and the Environment
Sponsored Links
Learn how to get your own Amazon Book shop | |
