Excel 2007 Power Programming with VBA

by John Walkenbach

Offers procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic[registered] for Applications.

Genres: Programming, Reference, Computers, Software, Nonfiction

1104 pages, Paperback

First published January 1, 2007

Reviews

[Philip Dahlheimer · Rating 5 out of 5]

Very informative. This book solve a major problem I had with Excel where the menu would scramble after 5 or 10 minutes. With John's one suggestion about deleting an excel registry folder it solved the problem. The book is worth its weight in gold just for that.
Beyond that the many, many examples of coding, all were very clear and straightforward.

[Fer Prz · Rating 5 out of 5]

After reading this book I achieved my goal of having the ability to automate most tasks and create cool applications.

[Jonathan · Rating 5 out of 5]

If you want a single book to learn VBA then this (or a later version) is ideal. I'd tried a couple of other books before I got to this one and although they were useful there always seemed to be something lacking.

This book goes totally overboard in starting off telling you about the history of Excel, VBA etc. and what's new about Excel 2007. Only by page 189 does he start going into VBA properly. For the beginner this is a very gentle introduction and the rest of the book is a very good guide to VBA packed with examples.

Other reviewers on Amazon and here have commented on the atrocious index which is practically useless. However it does come with a pdf version of the book and you can use the search functions on the pdf reader to find anything you want.

[Craig · Rating 3 out of 5]

This is a good book. I have probably read about 70% of it, mainly to inform my (currently) basic understanding of VBA and to better craft my VBA-writing techniques. It has served me well--but I have yet to find more real example based teaching in textbook form. Most of the book is quite comprehensive and function-based, as opposed to problem-based. One of the great things about it is the CD-Rom with .pdf of the book on it--so you can (ctrl+f) search for pieces of information from the book very easily.

[Lianna · Rating 5 out of 5]

I am in love with this book! Short and to the point with his personal tips only adding to the learning parade and are 100% ramble-free.

It's a forearm burner though, the thing must weigh 9 pounds.

[Steven Sanderson · Rating 4 out of 5]

I refer to this often as I am now required to write vba, something I have not yet done.