Excel 2002 Power Programming with VBA

List Price: $49.99 Amazon.com Price: $34.99

---

Product Details

• Media: Paperback
• Publisher: John Wiley & Sons (July, 2001)
• ISBN: 0764547992
• Average Customer Review: Based on 16 reviews.
• Amazon.com Sales Rank: 2,308
  

---

Customer Reviews

Good for beginners and intermediate alike

As someone who has some programming experience, this book was very helpful to me.
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 O'Reilly Press' 'Writing Excel Macros with VBA'. Where certain areas aren't covered in this book (rare), there will almost ceratinly be something in the other.

As an intermediate level part-time but somewhat rusty programmer (mostly self-taught) of Java, C, Javascript, HTML, CSS, XML, Assembly and others, this book certainly had what I was looking for.
It offers useful language references and the descriptions are ample, although occasionally apparently useful methods that were covered in 'the other' book and were overlooked in this one; it's just not possible to include everything though, even in ~1000 pages.

It assumes some prior knowledge of programming techniques, and is therefore not for the absolute beginner, but will serve it's purpose very well indeed to the majority.

I would recommend this book all except the absolute beginner and the advanced programmer/expert (who probably wouldn't be reading this anyway!). Definatly worth the money.

I rarely buy books on the internet without having a good flick through them at the local bookshop first. In this case I would definatly advise likeminded thinkers to make an exception.

The included CDROM is worth it's weight in gold and is all too often a crucial ommission by authours/publishers. I can now take the book with me on my laptop in PDF format (hooray!) and all of the book examples are included too. BONUS!


A well written book

I went over this book twice. Although I believe I understood most of it, I am not yet a power programmer.
This book is an intermediate book on Excel programming. Don't expect to become an expert from it. The book is very well written and John Walkenbach writes in a way that no other programmer does. The book stimulates the interest of the reader into Excel. The examples are well explained. I did not give this book five stars because the Windows API is not explained in depth.
According to me the path of the books to Excel programming is:
1 Excel The Bible( the second half of the book)
2 Excel for Power Programmers
3 Excel 2002 VBA Programmer's reference
The last book in the list is not for inexperienced programmers and is not as pleasant to read( So do not start with it).
I also recommen Excel 2002 formulas if the would be programmer does not have an extensive experience in Excel


Great book--highly recommended

I am a real estate finance analyst and researcher who wanted more control over the manipulation of my data in Excel as well as learning how to create user forms. John Walkenbach's "Excel 2002 Power Programming with VBA" was an informative and excellent resource that taught me most of what I was looking for. Walkenbach begins with a brief explanation of Excel and the fundamentals of object-oriented programming (OOP), which underpins VBA. The reader has to be patient and be willing to experiment; working through Walkenbach's examples with Excel open is almost a must.

There are several issues that I would like to point out. One reviewer was upset over the fact that Walkenbach did not offer some utilities from the book's CDs for free. I did not try any of the utilities because I was more interested in the book's actual contents and explanations. Walkenbach does, however, offer the reader a full and unrestricted PDF version of the book in the CD, which I think is mighty generous of him. Instead of lugging the +1,000 page book, I sometimes leave the PDF version on my laptop so I could always have it with me. Lastly, I use Excel 97 at work and Excel X on the Mac at home, and despite some minor incompatibility issues, I would say that the book for the most part could be used for all versions of Excel 97 and up.

BTW, I would also recommend "Excel 2002 VBA" by Bullen, Green, Bovey, and Rosenberg published by Worx Press for a more advanced treatment of VBA.

---

RECOMMENDED Microsoft Excel - VBA books

Advanced modelling in finance using Excel and VBA Writing Excel Macros with VBA, 2nd Edition Excel 2002 Power Programming with VBA Learn MS Excel 2002 VBA/XML Programming Definitive Guide to Excel VBA Microsoft Excel VBA Programming for the Absolute Beginner VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel Microsoft Excel 2002 Visual Basic for Applications Step by Step

RECOMMENDED MICROSOFT EXCEL TIPS

Applying Colors to Maximum/Minimum Values in a List Retrieving the Closest Larger and Closest Smaller Values from a List When There Is No Exact Match Extracting the First N Number of Words from a String Extracting Characters from Text Using Text Formulas Finding the maximum value of all those meeting a certain criteria. Adding the Path Address to the Header/Footer Adding a Comment to a Formula Retrieving From List By Position Counting Unique Numeric Values or Unique Data in a List Changing the Default Date Separator from a Slash to a Dot When Entering a Date into a Cell