Comments about oreilly Writing Excel Macros with VBA, Second Edition:

Writing Excel Macros w/ VBA is an great book that with just a little work anyone can master the information presented. If your looking for the lazy man's books that requires no thinking this book is not for you. On the other hand if you want to unlock the true power of Excel there isn't another book in print currently that can hold a candle to this one!

Comments about oreilly Writing Excel Macros with VBA, Second Edition:

I can honestly say, that with my rather small programming background, and this book, I have not only increased my value to a company, but I have also been able to get a much better job. You do not need to be a hard-core programmer to find this book useful, but you still do need some basic programming background. If you do have the background, and you work in Excel to any degree, this really is a must-have.

Comments about oreilly Writing Excel Macros with VBA, Second Edition:

Writing Excel Macros w/ VBA is an excellent book if you already have some structured programming experience. Only the first 100 pages or so of the book cover programming -- the remaining 400 pages focuses on Excel collections, properties and methods.

The sections on custom menus, pivot tables and charts are excellent, as is the focus on how Excel interprets what you put in. I especially appreciate Steven Roman's notation of what is the default choice within each method.

More importantly, although this book's 2nd edition was published in 2002, the object model hasn't changed all that much, and the tools learned here can be applied to any version.

As a result of using this book, my code is tighter, much faster and easier to read.

Comments about oreilly Writing Excel Macros with VBA, Second Edition:

I liked this book. It has only the most important subjects and are presented logically. I think the author expects you will have some common sense or some other db or programming experience. Your time isn't wasted on stuff that isn't useful. You can get all the basics and look things up easily. I also used Oreilly books on Unix and AWK and SED. I liked this book also.

Comments about oreilly Writing Excel Macros with VBA, Second Edition:

Sorely disappointed in this book (disappointed enough to write my first review!). I had hoped, expected, that as an O'Reilly book I could trust it as I have done many times in the based with Unix books, SED, AWK, etc. The title says "Writing Excel Macros" and I expected how to examples, step-by-step process, building actual macros from start to finish. Yet chapter after chapter is just more detail on Excel objects, without anything that puts this information into useful context. If anything, the title should be "Reference book for Excel Objects" and it would have hit the mark. I just wasted $40.

Comments about oreilly Writing Excel Macros with VBA, Second Edition:

This book provided a straight forward step into VBA programming. I had used Excel a lot and was used to using compound If statements and conditional formatting to achieve the results I wanted. Using VBA moved me on to a higher level and allowed me to develop Excel spreadsheets that worked the way I wanted them to rather than me having to work to the way my spreadsheet was demanding.

What marks this book as very good is that not only did I find it good to start with, but it continues to be a useful guide. I read the first quarter and that gave me enough to take on most of the tasks I needed to do at the time. However after I became more familiar with VBA, I found I needed more in depth knowledge and I was able to return to the book and progress further.

Recently I have brought "VB & VBA in a Nutshell" and this complements this book very well.

Comments about oreilly Writing Excel Macros with VBA, Second Edition:

Very clear examples in a book on an uncommon (or uncommon to be totally devoted) topic.