Monday, 19 January 2009

Excel VBA - books and links

Four web sites:
Three Books:

Excel VBA Programming for Dummies
John Walkenbach

This is full of quick simple and easy to use VBA tips. You can pick this up and benefit from it without any prior knowledge. If you are going to follow this thread and don't have any prior experience programming it would be really useful to have a copy handy.


Professional Excel Development:
The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
Bullen, Bovey, Green.
I love this book. Full of best practices, programming tips and working examples.
And you can read it. If you are happy with the basic elements of VBA this should be useful. I can't say that I have read the book cover to cover (I do have a life) but I use a lot of the code in my own development. And it is worthwhile reading the best practice hints and tips before starting any serious development.

Excel 2007 VBA Programmer's Reference
John Green, Stephen Bullen, Rob Bovey, Michael Alexander.
This much more of a reference book and, while I have used snippets of code, I have not read the book from cover to cover. (Come on, it's a reference book - let's use it for reference).

No comments:

Post a Comment