Excel 2010 Power Programming with VBA

by John Walkenbach

All the methods and tools you need to successfully program with Excel John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA. This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Genres: Programming, Reference, Nonfiction, Software

1052 pages, Paperback

First published April 6, 2010

Reviews

[Chris · Rating 5 out of 5]

This book really developed me professionally, at least from a programming perspective. It got me started on VBA code and then gave me ideas as a reference to progress in complexity. It can easily be a stand alone guide for the basics and with a little ingenuity can allow the individual to progress to more complicated code.

This book contains the basics, loops, pathways etc of VBA. Lots of code snippets for user forms and complex interactions. It, however, doesn't get into advanced topics on a deeper level, but if you are interested in that kind of thing you should learn to use Google and read some papers. Hint Hint, for any VBA programmer research class association with Excel Application. Combined with the above book you can write some great tool bars that have great scope!

[Nathan · Rating 4 out of 5]

Simply a great book for getting a handle on Visual Basic for Applications (VBA) in the context of Excel, or for a quick refresher if you haven't coded in a while / are transitioning to the 2010 object model from an older version. Highly recommended. Full of example code, shortcuts, and tips and tricks.

[May Ling · Rating 5 out of 5]

Excellent. A big improvement on VBA for dummies! For the beginner that already has figured out the dummy's book, this is the perfect next step. Great step by step instructions. Lots of examples. Advanced sections are great. It will take me some time before this all becomes old hat for me.

[Md Alif · Rating 5 out of 5]

Nice

[Ariyasacca · Rating 2 out of 5]

Ch9,Ch27. Too easy

[Manny Tingplants · Rating 5 out of 5]

This is a great introduction into both the VBA language and programming against Excel in general. It took me from an intermediate Excel user with some outside programming experience to a VBA wizard in months. I now use C# wherever possible for Excel automation, but continue to refer back to this book for tips about Excel's features and quirks. VBA is not the best tool for a lot of jobs, but it is fast, easy, and powerful. Walkenbach knows what he's talking about.

[Jon · Rating 5 out of 5]

Great book with lot's of good information. Although not as essential as "Professional Excel Development", "Excel 2010 Power Programming with VBA" is a nice how to where the other book is a what you can do.

This book also gave some good examples of what is possible in programming Excel.

[Gary · Rating 3 out of 5]

Mr. Walkenbach does a nice job reviewing VBA, focusing on 2007 and 2010 iterations. Although he covers VBA from the beginning, he doesn't go into all of the basic Excel usage. A good addition to the library for VBA developers.

[Doron Yam · Rating 4 out of 5]

A good proffesional book that teaches us the basics (and some tricks) about VBA programming in Ecxel.

[Sahil · Rating 4 out of 5]

good book

[Andy · Rating 5 out of 5]

Read the first half doing the exercises. Skimmed the second half. Great reference.

[Tim · Rating 2 out of 5]

I did not find this book all that great. Granted, it's rather outdated (a lot has happened since Excel 2010), but that's not my beef with it. I was looking for a solid, methodical explanation of core Excel VBA programming concepts, which are more or less the same in every version. Something to bring order to the things I already know, and maybe pick up a few new tricks. The table of contents looks like this book will deliver, but in reality, after a decent start, things quickly deteriorated into a hodge-podge of "neat tricks", perfunctory explanations, and not-so-useful examples dealing with all kinds of random aspects of Excel presented in no semblance of order and only vaguely grouped under the chapter headers. The author definitely knows his stuff, but he is not at all good at dishing it out in a consistent way. If anything, I'm now more confused about the VBA object model than I was when I started this book. Oh well. Time to find something dealing with newer versions anyway.