Microsoft Excel 2002 Visual Basic for Applications Step by Step

List Price: $39.99 Amazon.com Price: $27.99

---

Product Details

• Media: Paperback
• Publisher: Microsoft Press (October, 2001)
• ISBN: 0735613591
• Average Customer Review: Based on 6 reviews.
• Amazon.com Sales Rank: 4,705
  

---

Customer Reviews

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.


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.


Just for Beginner

A very good book for beginner. Just for beginner!!
If you are not beginner, don't waste your money.
If you are not office clerk, I don't suggest it.

---

RECOMMENDED Microsoft Excel - VBA books

Advanced modelling in finance using Excel and VBA Writing Excel Macros with VBA, 2nd Edition Excel 2002 Power Programming with VBA Learn MS Excel 2002 VBA/XML Programming Definitive Guide to Excel VBA Microsoft Excel VBA Programming for the Absolute Beginner VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel Microsoft Excel 2002 Visual Basic for Applications Step by Step

RECOMMENDED MICROSOFT EXCEL TIPS

Dividing a First Left Heading Title Calculating the Average of Every Nth Value, Excluding Zeros Adding the full path of the saved file to headers and footers in Microsoft Excel 2002 xp Reversing the Word Order within a String Separating First and Last Names Without Using Formulas Using the Keyboard to Select Chart Items in Microsoft Excel Removing Icons Performing Two Different Tasks Automating the Insertion of the Euro Symbol Drawing Lines Between Sorted Groups Adding Time Values from Separate Hours and Minutes Columns