Python Programming On Win32

This is not installed under the standard Office Setup; you need to rerun Office Setup, choose Custom Setup, and explicitly select the VBA help.

After reading Chapter 5, you’ll discover that Python can build a complete wrapper around Excel’s object model, documenting all objects and properties. This doesn’t tell you what all the methods do but provides a comprehensive and remarkably readable listing of the objects and methods.

This book describes how to build custom applications using all the Office applications. There is a general overview of Excel but not enough detail on Range objects.

This book devotes 500 pages specifically to building applications in Excel. Regrettably, the majority focuses on GUI development and perhaps only 10% of the book relates to what you might use with Python. If you are developing routines in Excel VBA, this is the best reference.