I am an experienced developer notably in C#. I need to help a non-programmer friend get thigns done with Excel VBA. What is a good book for me to quickly pick Excel Macros & VBA up so that I can help my friend?
We're using Excel 2007.
views:
286answers:
4
+6
A:
A couple of books that I have had on my shelf for some years and served me well in the early years to get to grips with Excel VBA were:
- Excel 2002 Power Programming with VBA - John Walkenbach
- Excel 2002 VBA (Wrox Press) - Bullen / Green / Rosenberg
The Walkenbach book is slightly more comprehensive I think with more practical examples. However, the layout is better in the Wrox Press book and on the occasion that I have forgotten how to do something I will refer to Wrox first.
Either book will give you what you need I would think.
Remnant
2009-01-01 10:40:31
Thanks. I checked out both books updated for Excel 2007, and I think I prefer the second one. The primer (Chapter 1) already succinctly put me on the right track to figure out many useful tricks.
namin
2009-01-01 16:44:08
I've had excellent results with several of Walkenbach's books.
Stewbob
2010-03-10 21:17:21
A:
If you're experienced, I don't think you'll need any book. Have you tried to google on 'VBA for Excel 101'? Once you're on the tracks, you'll make it on your own!
Philippe Grondier
2009-01-05 16:00:40
+1
A:
Have a look at Professional Excel Development. I recommend the second edition. It has everything that 1st edition has and some extra material.
Niketya
2010-04-21 14:54:37