Solved: Good books?

[tkaplan]

I have a good computer background, (degree in computer science) but i think i am missing a lot of the basics in programming with VBA. I can usually figure out most of what i need using the record feature and then modifying , and then, of course, posting my questions here.

I am looking for a book that is really good in teaching all of the excel related objects and events. Can anyone recommend something?

Thank you.

[johnske]

There's lots of things around, but a good start is Microsoft Office97 Visual Basic Programmers Guide as most of what's written there still applies to later versions.

The last time I pasted the main link it wouldn't work, so here's a link to one chapter that you can then follow to the others (about 15 in all) http://msdn.microsoft.com/archive/en-us/office97/html/web/004.asp hopefully, this one works

Regards,
John

[Ken Puls]

I highly recommend John Walkenbach's Excel Power Programming With VBA (http://j-walk.com/ss/books/xlbook25.htm) series. I have the 2002 version, and it's awesome.

If you are at the stage where you can modify you're recorded code, I think you'll find the book at the right place for you. It starts with some pretty basic stuff, but takes you into it at a good pace. The 2002 version also came with the book in pdf on CD, so you could keep a copy at each work and home if you're a true geek (like myself! LOL!)

[mark007]

I recommend Excel 2002 Programmer's Reference.

:)

[shades]

To piggy-back onto Walkenbach, consider VBA and Macros for MS Excel by Bill Jelen (MrExcel) and Tracy Syrstad.

[malik641]

I highly recommend John Walkenbach's Excel Power Programming With VBA (http://j-walk.com/ss/books/xlbook25.htm) series. I have the 2002 version, and it's awesome.

[Brandtrock]

I highly recommend John Walkenbach's Excel Power Programming With VBA (http://j-walk.com/ss/books/xlbook25.htm) series. I have the 2002 version, and it's awesome.

If you are at the stage where you can modify you're recorded code, I think you'll find the book at the right place for you. It starts with some pretty basic stuff, but takes you into it at a good pace. The 2002 version also came with the book in pdf on CD, so you could keep a copy at each work and home if you're a true geek (like myself! LOL!)

If you get John's PUP utility, pay the extra fee to be able to view the source code. You'll pick up a ton of good hints in there as well.

[MWE]

I highly recommend John Walkenbach's Excel Power Programming With VBA (http://j-walk.com/ss/books/xlbook25.htm) series. I have the 2002 version, and it's awesome.


I agree with kpuls, Walkenbach's book is excellent. J-Walk's book is quite focused on Excel; "VBA Developer's Handbook" by Getz and Gilbert is more general. I also like Rahmel's "Visual Basic 6 Programmer's Reference" (very easy to use).

[tkaplan]

Thank you. I will try the different suggestions.