|
Microsoft Excel 2002 Visual Basic for Applications Step By Step
 |
Author: Reed Jacobson
List Price: $39.99
Our Price: Click to see the latest and low price
ISBN: 0735613591
Publisher: Microsoft Press (12 September, 2001)
Edition: Paperback
Sales Rank: 8,862
Average Customer Rating: 3.71 out of 5
|
Customer ReviewsRating: 5 out of 5
Jacobson is clear and concise for learning the Range Object
I read this book two editions ago and it helped me convert all the workbooks for a large California bank from Lotus and older Excel formats. The book teaches you to use the Range object which is the main Object in Excel. Once you know it you can do most things with a little help from the great macro recording facility of Excel--you just generalize a few terms and apply your new knowledge of the Range Object. Thank you Reed!
Rating: 4 out of 5
Good First Introduction, A Trainer For Non-Programmers
This book is clearly a training manual for non-programmers wanting to do Excel macros. It is not intended for experienced programmers except as a quick overview. Nevertheless, the author introduces object-oriented programming terminology early and uses it consistently in an easy (most of the time), non-threatening way. Non-programmers, who carefully work through each of the excellent examples, without knowing it, will have picked up the basics of object-oriented programming while finding countless ways to automate their day-to-day work.As macro writing becomes more and more like regular programming, learning to use an editor and program development environment becomes more important. Nice use is made here of the VB Editor with emphasis on the Object Browser and the Immediate window - preparing the reader for perhaps moving on to more sophisticated development environments such as Visual Studio, which of course is not covered in this book. (Programming Office applications is included in the latest Visual Studio beta.) It is a joy to find a book that teaches macros with VBA in a way that permits easily moving on to more general software development with VB. The early Office macro languages were well removed from "real" programming; but VBA has changed that. OK, so perhaps it is softball and not baseball. This is a great book to give to an administrative Microsoft Office workaholic who is restless for more knowledge and might just become a self-taught developer. This book has a 2001 copyright; but as I write in July 2003 I still cannot find a better first book for VBA with Excel for non-programmers. On July 24, 2003, I want to add that there are two speed bumps in the book where the content is decidedly more difficult than the balance of the book. The first, midway through the book, is a chapter on manipulating Pivot Tables; and the second is an overly-fancy final chapter with lots of Pivot Table and graphics content. Both of these chapters are useful; but the level of difficulty seems two steps up from the other chapters. Perhaps these two chapters prompted some of the negative comments by others. You can safely skip these two (of twelve) chapters if you wish.
Rating: 5 out of 5
Outstanding resource
The easy to understand text and practical examples in the book have enabled me to really exploit the potential of Excel. Reed really understands the nuts and bolts of the application and communicates that to the reader.
Similar Products
· Excel 2002 Bible
· Microsoft Excel 2002 Formulas (With CD-ROM)
· Excel 2002 Power Programming with VBA
· Microsoft Access 2002 Visual Basic for Applications Step By Step
· Excel 2002 VBA: Programmers Reference
|
