Features
- Cover Type: Paperback with 368 pages
- Published by: Microsoft Press; Pap/Cdr edition September 12, 2001
- Written in: English
- ISBN 10 Number: 0735613591
- ISBN 13 Number: 978-0735613591
-
Book Dimensions:
9.1 x 7.4 x 1.1 inches
- Weighs: 1.6 pounds
Book Description
Teach yourself just what you need to know about developing with Excel Version 2002 Visual Basic for Applications.This title, aimed at beginner developers, is a teach-yourself guide to creating custom
software solutions, automating tasks, and taking creative control of Excel Version 2002 by exploiting its built-in programming language,
Microsoft Visual Basic for Applications (VBA). You'll learn to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, and more. The popular Step-by-Step method lets you choose your best starting point, and the easy-to-follow lessons include clear objectives and real-world business examples so you can learn exactly what you need to know, at your own speed. Prepared by an author with extensive knowledge of VBA and Excel, this book includes numerous screen shots that illustrate specific step-by-step programming procedures, plus a companion CD-ROM full of practice files that are tightly integrated with the lessons.
Reader Reviews
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.
Comment | |
(Report this)
Search for books at
