ACCU Home page ACCU Conference Page
Search Contact us ACCU at Flickr ACCU at GitHib ACCU at Facebook ACCU at Linked-in ACCU at Twitter Skip Navigation

Search in Book Reviews

The ACCU passes on review copies of computer books to its members for them to review. The result is a large, high quality collection of book reviews by programmers, for programmers. Currently there are 1949 reviews in the database and more every month.
Search is a simple string search in either book title or book author. The full text search is a search of the text of the review.
    View all alphabetically
Writing Excel Macros
Steven Roman
1 56592 587 4
Graham Kendall
MS Office
Appeared in:
Although this book was not requested by ACCU I was really happy to see it featured on the book list. More times than I care to remember I have tried to write Excel Macros, with some success, but I have never really felt confident about the subject. The help text (normally pretty good for most subjects) seems to be lacking in the area of writing macros and any books for Excel seem to relegate the subject to an appendix, preferring to concentrate on how to copy cells and other subjects that most people know how to do anyway.

To get a book dedicated to this single subject is a godsend to anybody who wishes to develop his or her skills in this area. Fortunately, the book does the subject justice and after describing the VB development environment and programming language, the Excel object model is discussed. This is a revelation in itself as suddenly you find you can control Excel from other applications (okay, we know it was possible but did you know how?).

By this stage of the book the hard work is done. The remainder of the book discusses how to apply VB and the Object Model to write what are in effect programs for Excel (I think they are more than macros which, by my definition, are recordings of key strokes).

If you want to learn how to write Excel macros, I would recommend this book and it is good to see a computer book of this quality priced at under twenty pounds.