Microsoft Excel 2000/Visual Basic for Applications Fundamentals [With (2)]

by Reed Jacobson

Book Overview

A fast, easy way to learn to program with Visual Basic for Applications, to extend and modify Microsoft Excel behavior, and to take full advantage of the Internet. The easy-to-follow lessons include... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0735605939
• ISBN13: 9780735605930
• Release Date: May 1999
• Publisher: Microsoft Press
• Length: 346 Pages
• Weight: 1.75 lbs.
• Dimensions: 1.2" x 7.3" x 9.1"

Customer Reviews

Not for beginner's but good

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.

très bon livre de départ

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!

Good for class, not for a non-programmer

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.

Its Great

Its a very good book and I wish all users of Excel will get this book

Great starter book for people unfamiliar with VBA Excel

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.