Writing Excel Macros with VBA, 2nd Edition

List Price: $34.95 Amazon.com Price: $24.47

• Media: Paperback
• Publisher: O'Reilly & Associates (15 June, 2002)
• ISBN: 0596003595
• Average Customer Review: Based on 3 reviews.
• Amazon.com Sales Rank: 15,787
  

The project I am working on was already defined, and all I had to do was look in the books where an example was given or a syntax reference existed. Note that I used it in alongside Walkenbach's Excel 2002 Power Programming with VBA. Where certain areas aren't covered in this book (as it's only 500 pages), there will almost ceratinly be something in the other.

As an intermediate level part-time programmer (mostly self-taught) of Java, C, Javascript, HTML, CSS, XML, Assembly and others, this book certainly had what I was looking for.
It mainly offers concise language references and the descriptions are kept to the necessary, and this O'Reilly book is a vast improvement on some that I have bought for other languages in the past.
It does however assume some prior knowledge of programming techniques, and is therefore not for the beginner.
I would recommend THIS book only to those who have either a very keen interest in programming or those who have had some formal programming teaching. Definatly worth the money though.


Not helpful for an intermediate programmer

When purchasing this book, I already had in mind the macros that I wanted to program and the logic I was going to use in order to accomplish the task. All I was really looking for was a breakdown of the syntax in VBA (I'm new to the language), and a list of commands that were available. Trying to extract this information from the book was tedious at best. It would have also been useful if there was an example or two of how some of the basic syntax works. I can only really use it as a second reference from the help menus already provided in excell and the online microsoft tutorial... suggest checking out that link and thumbing through the book at a store before buying it.


Only mathematician can write this book

I don't know why this book is labeled as "2nd Edition". The cover is the 3rd "face" I have seen. I did learn good stuff from the previous editions, but never recommend it to anybody for its' dry. The new edition has a big change. It is succinct, reader-freindly, but also contains many useful information you won't find in other books. For instance, there is no any other book goes so depth into Pivot Table properties and methods. Comparing with the Excel 2002 VBA books written by John Walkenbach or Stephen Bullen and John Green, this book definitely presents more real 2002 features. If you want to learn more about Excel 2002 objects, get this book.

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books