views:

191

answers:

2

A coleague of mine has shown interest in learning a little about vba scripting. Unfortunatelly, I don't have time to show her, and even if I did, I'm horrible at explaining things to people.

Can you recommend a good VBA book for someone who's never done any programming, that is, has a nice easy approach with lots of examples ?
I've checked out a few Amazon references, but in most cases user reviews there go from "yeeah, great book" to "this book sucks" ... not making it any easier to conclude anything.

+4  A: 

I think that John Walkenbach's Excel 2003 Power Programming with VBA is the best resource for Excel VBA but it might be a little much for a new programmer. Walkenbach also wrote Excel VBA Programming For Dummies.

Daily Dose of Excel has a recommended book list. Plus the blog itself is a good VBA resource.

Mark Lavin
I don't have that Dummies book on my list? I'll be fixing that shortly. I agree that for a new programmer, the best progression is Dummies - Power Programming - Professional Excel Dev
Dick Kusleika
+2  A: 

You do not say which MS application your colleaugue wishes to try. There have been previous threads:

http://stackoverflow.com/questions/483086/book-recommendation-for-visual-basic http://stackoverflow.com/questions/277474/programming-excel

Remou
Excel mostly. We are an engineering company, and people who are less inclined to programming do mostly everything in excel and matlab.
ldigas
Yes, the information was derivable from his proper use of tags;)
Oorang