Steven M. Hansen | Sybex
1 A Good Excel Programming with VBA Book
This is a very well written book, but it is not for beginners. I enjoy reading every page.
2 Excellent, Excel VBA without macro recorder
This is the best book on Developing with Excel I've read (still reading). It is now known that Excel's macro recorder sometimes produces inefficient and un-maintainable code. So, the author doesn't waste time with the macro recorder, instead he goes directly into VBA. I particularly like his treatment of GetOpenFilename, GetSaveAsFilename, and "Breaking down into path and File name components". Chapter 11 on "Developing Class Modules" is also excellent in introducing this complicated subject gently. Besides, the concepts learned here can be applied to other Microsoft applications such as Access.
He has managed to present the material in just 585 pages in a logical manner. I always had the impression that programming books over 1000 pages are less approachable and therefore less useful than books under 1000 pages.
Congratulations and many thanks to the author Steven Hansen.
