Microsoft Excel 2000/Visual Basic for Applications Fundamentals

Rating:
Summary: Good for class, not for a non-programmer
Review: I am using this book as the textbook for a class that I'm teaching on VBA in Excel. This book is good for use in a class because I'm there to clarify a lot of issues. I don't think the book is very good for a non-programmer who is trying to learn VBA. The author assumes that the reader has a decent understanding of programming in general, and in specific an understanding of objects. The students who have looked through the book like it and are ordering their own copies (one copy was provided to each for in-class use). The book has real applications, which is extremely useful for helping students remember what they did. The author uses a different programming technique than I, so I am learning new ways of writing code. To improve the book, I would explain the concept of a variable and object in the first chapter.

Rating:
Summary: Good for class, not for a non-programmer
Review: I am using this book as the textbook for a class that I'm teaching on VBA in Excel. This book is good for use in a class because I'm there to clarify a lot of issues. I don't think the book is very good for a non-programmer who is trying to learn VBA. The author assumes that the reader has a decent understanding of programming in general, and in specific an understanding of objects. The students who have looked through the book like it and are ordering their own copies (one copy was provided to each for in-class use). The book has real applications, which is extremely useful for helping students remember what they did. The author uses a different programming technique than I, so I am learning new ways of writing code. To improve the book, I would explain the concept of a variable and object in the first chapter.

Rating:
Summary: très bon livre de départ
Review: J'ai commencé avec le livre de John Walkenbach et ensuite j'ai terminé avec le livre de Reed Jacobson; j'aurais dû faire le contraire! Le livre de Reed donne un bien meilleur départ pour visual basic, explique mieux ce que sont les objets et méthodes, les contrôles active-X, etc. Par contre, il est beaucoup axé sur les excel (pivot tables, pivotcharts, etc) et il faut bien comprendre Excel avant de comprendre les macro. John est plus axé sur le langage des macro. Les deux livres sont complémentaires; il faut les deux!

Rating:
Summary: très bon livre de départ
Review: J'ai commencé avec le livre de John Walkenbach et ensuite j'ai terminé avec le livre de Reed Jacobson; j'aurais dû faire le contraire! Le livre de Reed donne un bien meilleur départ pour visual basic, explique mieux ce que sont les objets et méthodes, les contrôles active-X, etc. Par contre, il est beaucoup axé sur les excel (pivot tables, pivotcharts, etc) et il faut bien comprendre Excel avant de comprendre les macro. John est plus axé sur le langage des macro. Les deux livres sont complémentaires; il faut les deux!

Rating:
Summary: Not for beginners
Review: The book does not do a good job with the fundamentals of VBA. Very brief in its explanation of objects, properties, and methods. Gives plenty of examples but often refers you to Excel help to find out more info about a particular item. If I wanted to do that I would not have bought the book. Very disappointed.

Rating:
Summary: Its Great
Review: This was my first book I used to learn the VB intricacies of Excel. Showed me step-by-step what is possible as far as developing a user application, with a VB fueled spreadsheet. One thing that I liked was code that removed all the users toolbars (makes the visual screen area maximized) and the upon closing, puts them all back. Had results in just about a week with some help from the Microsoft news groups (Excel related). Recommended as a starter for those unfamiliar with VB or Excel.

Rating:
Summary: Not for beginner's but good
Review: Those with no programming experience should not buy this book. It is helpful in the very detailed examples of what Excel VBA can do for you. The last chapter on Pivot Tables seems a little out of step with the rest of the book. Also, the theory behind what you are doing is not explored so it is a bit superficial. But, as far as getting your feet wet, this is a great place to start.