spreadsheets

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.

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!

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.