REVIEW - Writing Excel Macros


Writing Excel Macros


Steven Roman



O'Reilly (1999)




Graham Kendall


April 2000



To get a book dedicated to this single subject is a godsend

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.

Book cover image courtesy of Open Library.

Your Privacy

By clicking "Accept All Cookies" you agree ACCU can store cookies on your device and disclose information in accordance with our Privacy Policy and Cookie Policy.

By clicking "Share IP Address" you agree ACCU can forward your IP address to third-party sites to enhance the information presented on the site, and that these sites may store cookies on your device.