<< 1 >>
Rating: 
Summary: Always on my desk
Review: I am constantly using this book for reference and rarely do I not find an answer I am looking for.
Rating: 
Summary: Excellent book.
Review: I did not buy this book for a month because of some of the review comments, but then did go ahead and buy the book. I disagree with the negatives - this is an excellent book for anybody who has to write VB code for Excel. And there aren't THAT many bugs in the code, and those that are there are very minor. The comment about the "help" is unwarranted - I've been living in the "help" for two months now. Of the 3 books I have on this topic, this is the best one.
Rating:
Summary: Always on my desk
Review: Let me put this in clear, concise and 'hands-on' language. Before reading this book, I knew little about VBA. Right after reading it (and actually working through 80% of its examples), I was able to build a custom mortgage analysis application using MS Excel as the user interface and MS Access as the data source. I was able to set up and manipulate dropdowns (comboboxes) within spreadsheet cells to present parameter choices, and to programmatically create and manipulate graphs and pivot tables to display results in more meaningful formats. I also made extensive use of arrays and functions to cope with the many iterative calculations required. To add to all this, I was able to use DAO to query and update the Access database. Since then, I have been working on VBA for Access etc., only to find out that the foundation laid by John Walkenbach carries over excellently to all MS Office applications.
Rating:
Summary: Excellent technical writing.
Review: Mr. Walkenbach understands the predicament of the reader who does not have the time to read, but yet, needs to become proficient in the subject matter. This, coupled with his knowledge of the subject and his literary ability makes for an enjoyable experience. When will we have an Excel 97 encore?
Rating:
Summary: This is THE Excel Programming book
Review: The book was one of the most useful I read in learning to create Excel custom applications. It is written by some one who has actually struggled with making it really work. Other books often tell you VBA in Office has almost unlimited tools to accomplish a task and suggest VBA online help for further details, not a lot of help. The is written for Excel 95 not Excel 97 and needs an upgrade. Office 97 completely overhauled dialog boxes, toolbars, and custom menus. There are very few books that actually have the depth to help a serious designer of a VBA custom application, this is one. If you create Excel custom designs for others to use then add this book to your shelf.
Rating:
Summary: An excellent guide for custom application development
Review: The book was one of the most useful I read in learning to create Excel custom applications. It is written by some one who has actually struggled with making it really work. Other books often tell you VBA in Office has almost unlimited tools to accomplish a task and suggest VBA online help for further details, not a lot of help. The is written for Excel 95 not Excel 97 and needs an upgrade. Office 97 completely overhauled dialog boxes, toolbars, and custom menus. There are very few books that actually have the depth to help a serious designer of a VBA custom application, this is one. If you create Excel custom designs for others to use then add this book to your shelf.
Rating:
Summary: The CD alone is worth more than the price of this book.
Review: This book has saved me months of time in my struggle to write proficient VBA code in Excel. I'd recommend just looking over everything on the CD before reading the book. You will probably find the answers you've been looking for without even turning a page. The author has also included an order form to get the full version powerpak utilities for free (except for postage) and the source code can be purchased for a mere $20. I just received mine in the mail. Haven't had a chance to look at all the source code yet because I've been too busy playing Yatzhee (one of the three time wasters included with the powerpak. The tooltip utility included in the powerpak allows you to easily modify the tooltips on your custom toolbar buttons. Isn't that cool
Rating: 
Summary: Far Too Many Errors In the Examples
Review: This is a truly excellent book. Not only does it comprehensively describe all the VBA features in Excel, but it does so in a thoroughly understandable manner. Common algorithms, such as Quicksort are also addressed, as excellent examples. Though it has now outdated with the advent of Excel 97, I would continue to recommend it as a superb guide to VBA programming at the beginning-to-intermediate levels. It even discusses integrating your Excel programs with Access! Walkenbach has produced a masterpiece.
<< 1 >>
| 
