bordeebook offers this stuff with condition New, new for:

Price : $26.00 Usually ships in 1-2 business days

media-prime from CA, United States offers this stuff for:

Price : $26.00 Usually ships in 1-2 business days

woodys-books offers this stuff with condition New, new for:

Price : $27.18 Usually ships in 1-2 business days

BestBookDepot offers this stuff with condition New, new for:

Price : $27.19 Usually ships in 1-2 business days

bluehouse100 from MA, United States offers this stuff for:

Price : $41.60 Usually ships in 1-2 business days

What our customer's say!

"Awesome...", I can't recommend this book highly enough. There is a wealth of advice on best practice for both Excel and VBA, which has not only prompted me to change the way I design new projects, but to revise old projects also. There are also a huge number of examples, including an application developed throughout the course of the book, which demonstrate applications for all the techniques discussed. Definitely not for the beginner, but there's loads of stuff here for intermediate to advanced developers. I think I'll be using this as a desktop reference for a long time to come...

"Uh-oh! Be careful!", This book of advanced Excel development was recommended to me by a co-worker whose project I inherited that used the concepts in the book based on the "Petras Template" example. It's classy and polished VBA programming and sure, you can brag about the concepts to the techies interviewing you during your next job hunt.

But, be careful.

The book introduces us to the concept of add-ins and templates. So, there you are showing off your project to your manager or users. But, what do they click on? The add-in or the template? What are all those true/false cells over there? How can the user save the workbook? What heppens if you forget to hide the columns that use cell logic. Hmmm. These questions and others will be asked of your typically non-technical users who have NO idea what goes on behind the scenes. If they open up the template and screw around with the code or re-name the add-in, you'll have chaos.

To be fair, there's tons of advanced concepts to learn here and no doubt you'll benefit from them. But, remember, as a developer, your first goal is to produce a robust application. However, you may have click a couple of functions to get all tabs in your template to show. If you don't do that, you can't see them! Oh, and don't forget to save your add-in.xla or all your changes won't take effect.

Not for beginners or dummies, but for VERY careful developers!

"Applied compendium of best practices", When you search the web and most of the books around, you can find solution to your problems most of the time, but you are rarely sure it was the best way to do it and how it would fit to the rest of your code. The authors of this book are not afraid to tell what they suppose to be the best for you, along with full featured versions of code illustrating each chapter.

I found it easy to take the code from a sufficiently leveled chapter and adapt it to get just the application that I needed, knowing it would be fast, clean and complete at the same time, although I didn't understand all the details at first. Now, the book serves as a widely findable documentation for the packages that I make. Highly recommendable.

"A great how-to book for serious Excel users", When picking up this book, I was an advanced Excel user. Having discovered most of its features by trial-and-error, and coming from a fairly solid programming background, I understood well the interaction between the underlying object model and the sheets appearing on the screen to end users. I have also crafted many sophisticated worksheet formulas, and explored just about every suggestion of literature such as "Excel Hacks" and "Advanced Excel Report Development".

Professional Excel Development offers ideas and tools necessary for designing full-fledged, robust Excel-based applications. It does not spend time explaining how various features work, but rather goes into detail on how to put these features to best use.

Here is what I picked up from this book, together with the authors' Excel 2003 VBA reference:
* ways to leverage Excel's built-in features to avoid excessive coding
* advanced design techniques for using Excel as a WYSIWYG interface designer
* techniques for creating custom menu bars and programming their behavior
* various means of interacting with the user and simplifying their sessions by providing guidance as to which steps need to be taken
* restricting the Excel environment to take on the appearance of a product condusive of the goal stated in previous bullet
* using VBA in conjunction with the Excel object model to create powerful object-oriented structures for spreadsheet-based applications
* programming Excel-based solutions in an executable to provide a more standalone application
* using Windows API calls to increase robustness of the application

One key feature of this book is its consistent approach. The authors maintain a consistent structure, using the same application throughout the book for their "practical example" to demonstrate new features made available through the material in each chapter. Also, the "best practices" approach provides a level of consistency that is generally desired of anywhat sophisticated applications. Useable modules are provided on the accompanying CD, ready to be used in readers' own applications.

In the beginning, the authors explain the audiences for which this book may or may not be intended. They separate these into users, power users, VBA developers, Excel developers, and professional developers. The latter three categories of users will benefit the most from this book, each in his/her own way. VBA developers will learn how to use built-in features (I think this is where I started); Excel developers will learn how to incorporate Excel-based solutions into larger applications; Professional developers will be exposed to a great variety of "best practices", optimization techniques, and various other means for developing consistency in Excel applications.

If you do not fall into the latter three categories, you might not pick up much from this book. It is not useless to you, however; you can still find many worksheet/userform design techniques, and get an introduction to the kind of power VBA-based programming can offer. Nonetheless, you may be well-advised to start off with something simpler, such as John Walkenbach's Excel Power Programming (as alluded to by the authors of this book), simply because the present book assumes a good degree of knowledge and leaves much for the reader to figure out from the fully-functional examples provided - thereby covering the ground that it does.

Overall, this book makes for a wonderful reference to the various under-the-hood features of Excel. Even if you've already encountered many of the techniques described, and could technically discover them further on your own, it is useful to have them readily available in a single collection. Very few items are left out; application design, object-oriented programming techniques, database applications, debugging techniques, Office automation, and external interop are all covered here. Professional Excel Development is a solid reference to be consulted for years to come.


"Not a book for lBeginners", This is a great book for power programmers. But be aware, this book is not for those who want to learn Excel. It's just for those who know Excel and want to imrove their programming capabilities.

Read this reviews before You buy...

"Wisdom Packed into Every Page! Brilliantly Written", 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).




"Must Read", I have got this book. The comment on cover page says "it is for the serious developer who is creating advanced applications". Well... I say it is a must read for any VBA programmer who wants to write good quality code. 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 AM SURE ABOUT IT.

A BEAUTIFUL CREATION.

"This book is ten times worth its price!", Working with Excel since ten years and writing add-ins with VBA and also by using the C API, I can claim myself as an experienced user.

In this book the reader may find everything regarding add-in development with VBA, VB6 or C, which cannot be found elsewhere.

This book is REALLY a great source of information for me and I keep it always within easy reach on my desk. If the price for it would be ten times higher, it would be still worth it.

"The single best book on programming Excel", The typical Excel programming book is often like a VBA cookbook. Just a succesion of VBA code snippets and at the end the reader has a nice collection of VBA recipes, but doesn't really know how to cook. This book will show the reader how to cook.

From chapter to chapter the authors incrementally develop an Excel-based application. As they do this they skillfully introduce and interweave a number of development topics. Some topics are specific to Excel such as user forms, others are general like error handling. Each topic is discussed in isolation as well as it how interacts with the other aspects of the development process.

After just a few chapters I had a much better sense not only of the capabilities of the Excel programming environment but also how you can make it all fit together to achieve a highly functional and maintainable application. Highly recommended.

"High level and professional approach", Book for no VBA beginners and about professional applications.
A lot of explanations to help us in high level development.