Rating:  Summary: Great reference book! Review: This book has proved a life saver on more than one occasion. It is written in easy to understand language and organized in a way that doesn't force you to read the entire chapter to glean the one tidbit of information you were searching for. If you are looking for a tutorial style book, this isn't it, however if you are looking for a book that gives you answers quick - you're in luck. It has a thorough, helpful index. My one gripe is that I have found that the examples are a little scarce. I would like to see more examples of actual code. All in all, I am very pleased with my decision to purchase this book.
Rating:  Summary: Great Book. Review: This book is aptly named.
Rating:  Summary: Badly organised cd and book Review: This book is not for a beginner.
Rating:  Summary: Great Book. Review: This book was my bible for VBA & Excel while creating an application for work. I thought about getting Walkenbach's "EXCEL 2000 Power Programming", but my dad owned that one so I figured I could always borrow it if needed - but I never did need it. I had not written a single line of Visual Basic or VBA prior to getting this book - I learned everything I needed here. (Although I had plenty of experience in C++/Java). A few comments - I liked his style of mostly providing textual descriptions of all the different Excel classes, methods, and properties. There's not a lot of code in the book - but I never missed it. He provided clear enough descriptions of how to use the Excel object model, that I didn't need a ton of printed code to reinforce (don't get me wrong, there IS code within the book + the sample CD, just not pages and pages reflecting an entire application he's building up, like you get in a cookbook). If you prefer to just cut&paste code from a book into your own app, then you might be better off with Walkenbach's book. The book was originally written in German and then translated to English, but I only remember one or two times where that became evident. I wholeheartedly recommend this book.
Rating:  Summary: This book was my bible Review: This book was my bible for VBA & Excel while creating an application for work. I thought about getting Walkenbach's "EXCEL 2000 Power Programming", but my dad owned that one so I figured I could always borrow it if needed - but I never did need it. I had not written a single line of Visual Basic or VBA prior to getting this book - I learned everything I needed here. (Although I had plenty of experience in C++/Java). A few comments - I liked his style of mostly providing textual descriptions of all the different Excel classes, methods, and properties. There's not a lot of code in the book - but I never missed it. He provided clear enough descriptions of how to use the Excel object model, that I didn't need a ton of printed code to reinforce (don't get me wrong, there IS code within the book + the sample CD, just not pages and pages reflecting an entire application he's building up, like you get in a cookbook). If you prefer to just cut&paste code from a book into your own app, then you might be better off with Walkenbach's book. The book was originally written in German and then translated to English, but I only remember one or two times where that became evident. I wholeheartedly recommend this book.
Rating:  Summary: Advanced Excel VBA Material Review: This is a great book for the intermediate to advanced Excel VBA user. It covers many fine details missed by other Excel VBA texts. This does NOT make this text better than others that focus on basic skills for VBA Application programming. Beginners may get lost in the depth of the details but experienced users will be very happy with the depth of knowledge that makes the difference between a good application and a great application. Buy this book after you master the fundamentals. Highly recommended.
Rating:  Summary: Advanced Excel VBA Material Review: This is a great book for the intermediate to advanced Excel VBA user. It covers many fine details missed by other Excel VBA texts. This does NOT make this text better than others that focus on basic skills for VBA Application programming. Beginners may get lost in the depth of the details but experienced users will be very happy with the depth of knowledge that makes the difference between a good application and a great application. Buy this book after you master the fundamentals. Highly recommended.
Rating:  Summary: Excellent Review: This is an excellent guide to Excel VBA. I have programmed in VB for 12+ years, but have barely dabbled in VBA. I needed to develop some tools for Excel using VBA. I asked expert friends on Experts-Exchange (www.experts-exchange.com) and Open IT (pub21.ezboard.com/bopenitforum) and they gave me three highly recommended books. I look on Amazon and came up with about five to consider, include those three previously recommended. I looked at copies of those and others and chose this book as the one most likely to fit my needs. So far, I am not disappointed.
Rating:  Summary: Not for beginners Review: When I purchased this book I assumed that because I have some VB experience and am fairly well versed with Excel that this book would fill the gap for me to pick up VBA. Sadly, this was not the case. Specifically, the nuts and bolts of interest to a VBA beginner are for the most part placed in one mammoth 150 page chapter. The frustrating subject of addressing and manipulating ranges, especially across sheets, is not covered in any depth. Example code is scarce and I couldn't get some of the sample code to work at all. Some of the language is convoluted possibly a result of being translated from the original german. In fairness, I did not get much past chapter 5 so perhaps once I'm up to speed the rest of the book may prove more helpful. Also the index is quite good especially compared to some other computer books I've seen. If you're a beginner I would recommend J. Walkenbach's website on VBA for Excel. Also, chapter 14 of "Excel For Chemists" by E.J. Billo is an excellent source for learning how to reference ranges.
|