Writing Excel Macros with VBA, 2nd Edition Second Edition
Use the Amazon App to scan ISBNs and compare prices.
Frequently bought together
About the Author
Steven Roman, Ph.D., is a professor emeritus of mathematics at the California State University, Fullerton. His previous books with O'Reilly include "Access Database Design and Programming", "Writing Excel Macros with VBA", and "Win32 API Programming with Visual Basic".
- Publisher : O'Reilly Media; Second edition (June 15, 2002)
- Language : English
- Paperback : 574 pages
- ISBN-10 : 0596003595
- ISBN-13 : 978-0596003593
- Item Weight : 1.78 pounds
- Dimensions : 7 x 1.06 x 9.19 inches
- Best Sellers Rank: #101,770 in Books (See Top 100 in Books)
- Customer Reviews:
About the author
Top reviews from the United States
There was a problem filtering reviews right now. Please try again later.
This book's coverage of the Excel object model is by the far the best I have seen and is well organized and through. It explains the intent of the properties and methods rather than just explaining the syntax.
The author also details various caveats about how various components within the object model operate. This is very useful. As a simple example, he explains that setting the Chart objects .HasAxis property before the Chart has any data series defined will result in a cryptic error that is not covered in the documentation. Without this information one might end up blindly copying some ugly code from the macro recorder that seems to work though it wouldn't be clear just why this code worked while the other method failed.
If one is not already very knowledgeable of Excel and VBA, this book would probably work best accompanied by a book like Walkenbach's, "Excel 2003 Power Programming with VBA". Eventually however, this will probably become the "goto" reference.
Although there could have been a little more on interplay between Excel and the other Office objects, esp. Outlook, this book makes up for that with its clear, organised and logical presenatation.
I use it as a reference book, and seem to remember the content of it more clearly than I do with other comparable books! Why is this? Mr Roman has a tidy turn of phrase, doesn't wafffle, but his explanations seem to sit well in how my mind works. I hope this will be the same for you.
I recommend this book for those who may be beyond the beginner stage of learning VB(A). It also includes some handy utilities for users of Excel.
Mr Roman - well done. Look forward to your next (high level?) Excel VBA book.