REVIEW - Writing Excel Macros


Title:

Writing Excel Macros

Author:

Steven Roman

ISBN:

Publisher:

O'Reilly (1999)

Pages:

529pp

Reviewer:

Graham Kendall

Reviewed:

April 2000

Rating:

★★★☆☆


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 Non-Essential Cookies" you agree ACCU can store non-essential cookies on your device and disclose information in accordance with our Privacy Policy and Cookie Policy.

Current Setting: Non-Essential Cookies REJECTED


By clicking "Include Third Party Content" you agree ACCU can forward your IP address to third-party sites (such as YouTube) to enhance the information presented on this site, and that third-party sites may store cookies on your device.

Current Setting: Third Party Content EXCLUDED



Settings can be changed at any time from the Cookie Policy page.