References
- Excel Visual Basic for Applications online help
This is not installed under the standard Office Setup; you need to rerun Office Setup, choose Custom Setup, and explicitly select the VBA help.
- Your Python installation
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.
- Microsoft Office 97 Developer’s Handbook, Microsoft Press
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.
- Microsoft Excel 97 Developer’s Handbook, Microsoft Press
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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access