Book List
This is a list of books that I recommend or that have been recommended to me by someone I trust. If you click on them and buy them, I get money.
Update: Frank suggested I provide a place where people can comment on books they’ve read, so I’ve enabled comments for this page. I’ll be monitoring those comments closely, so keep them on topic please. Good suggestion Frank. Thanks.
|
 |
 |
| Excel 2007 Formulas (Walkenbach) |
Excel 2003 Power Programming in VBA (Walkenbach) |
VBA Developers Handbook (Getz, Gilbert) |
 |
 |
 |
| Professional Excel Development (Bullen, Bovey, Green) |
A Book on C (Kelley, Pohl) |
Excel Add-in Development in C\C++ (Dalton) |
 |
 |
 |
| C++ Primer (Lippman, Lajoie, Moo) |
Code Complete (McConnell) |
Excel PivotTables Recipes (Dalgleish) |
 |
 |
 |
| Excel 2002 VBA Programmer’s Reference (Bovey, Bullen, Green, Rosenberg) |
Excel Charts (Walkenbach) |
Excel 2003 Bible (Walkenbach) |
Roger:
My wife says this comment is unnecessary because you probably already know but: You da man! Here I was thinking that I was the greatest thing to ever grace a spreadsheet, then I picked up your book. I went from saying that I was an Excel Guru to saying that I was pretty good. Question, do you do any work or put out any resources on the functions in the Access’ Expression Builder? I once was able to download a dictionary of Excel Functions but I can’t seem to find anything about the ones in Access.
Rog
21 August 2007, 1:58 pmchip g:
I’ve read John Walkenbach’s Excel 2002 Power Programming in VBA, which I suspect is 90% the same as the 2003 version shown above. (I have the Polish version of the 2003 version, because I won it in a contest from him, but I can’t follow that very well.)
At any rate, I am a totally self-taught VBA programmer and do my programming usually as the end-user as well. Even so, I like elegant programming over kludges, and this book has been very helpful in illustrating good programming techniques.
Understanding an object-oriented language was very difficult for me. I had written macros since Lotus 123 1a and up to Excel 4, but when I started recording VBA macros and looking at the code, it was a mystery to me. I could create loops after recording, but how to use the model to my advantage escaped me. This book provided a good overview of the object model and many great examples. I refer to it often as a way to improve my code now or to determine how to accomplish something that seems impossible to do manually.
I wish I understood the Class Module section better, because I’d bet I have a lot of uses for it. I follow the basic idea, but the examples given didn’t provide me anything that made me say “aha! I can use this when I do _______!” Some more examples that are business-focused might be helpful.
I could do without the history of the spreadsheet at the start, but that seems to be a convention in computer books.
All-in-all, a fantastic book for someone who knows some programming technique and is starting out in writing VBA code.
25 September 2007, 7:16 pmKedar Kulkarni:
I was a classic VB programmer before I started with excel and then with macros(VBA). My recommendation has been always (and I am very proud to see all the books I recommended are here) as follows.
1. You want to get away with just functions and excel user interface go with JWs books excel bible and excel formulas.
2. You read those and are hungry for more and want to do more with vba then start with power programming in vba by JW.. (You are my favorite John).. Getz and Gilbert are good at this juncture but the book has too much of vb programming and advanced API than VBA programming.
3. The last but not the least in VBA.. If you think that you still want to do more after creating some addins in vba and downloading from cpearson, ozgrid, j-walk the last book to read will be Professional excel development by Bovey, Green which is awesome and also touches .net, vsto, com addins.
Then I went for VSTO books which I think is good if you want to become a true Office developer as looking at the way MS is pushing vsto/.net and the way they treated vb6, I dont see vba will be supported in/post office 13 (still long time though).
(I have not mentioned the other books XL 2003 vba from wrox and by MS Press which I found a bit techy to recommend to some novice users who were new to vb6.) In all a great collection and would like to see some VSTO books by Eric Carter, Eric Lippert and VSTO for mere mortals which touch Word, Excel, Outlook also. Thx
27 September 2007, 3:20 amTrevor Thompson:
Humanities Student in need of Help.
Can anyone help me construct an Excel formula that will 1) determine the length of characters for each word & 2) then distribute each word into a labeled row according to character length for the following Shakespeare quote? . . . “Friends, Romans, countrymen, lend me your ears; I come to bury Caesar, not to praise him.”
Many thanks!
28 February 2008, 8:51 amMaurice Ho:
Any recommendations on good books of VST), with good discussions on the transition between VBA and VSTO? How about VSTO for Mere Mortals?
2 March 2008, 9:47 pm