Excel 2010: Programación con VBA / Power Programmingwith VBA

by John Walkenbach

Excel 2010 es una hoja de cálculo extremadamente completa, con numerosas características desconocidas para el usuario común, como Visual Basic para Aplicaciones (VBA), el lenguaje de programación integrado en Excel y en otras aplicaciones de Microsoft Office. Excel 2010. Programación con VBA nos presenta de forma didáctica

Genres: Programming, Reference, Nonfiction, Software

992 pages, Paperback

First published April 6, 2010

Reviews

[Chris]

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]

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]

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]

Nice

[Ariyasacca]

Ch9,Ch27. Too easy

[Manny Tingplants]

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]

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]

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]

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

[Sahil]

good book

[Andy]

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

[Tim]

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.