By Andy Brown

Download files and exercises for this tutorial from https://www.wiseowl.co.uk/python/videos/python-programming/vba-win32/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

If you're a VBA programmer, you'll love the fact that you can get at the MS Office COM object models from within Python using the win32com.client module. This practical tutorial shows how to manipulate Excel and Word from within Python, how to translate VBA programs and how to list Outlook emails and download attachments in Python.

Chapters
00:00 Topic list
01:29 The VBA COM (Component Object Model)
03:29 A basic Excel VBA example
07:17 A basic Word VBA example
09:59 Translating a full Excel VBA program
20:38 Outlook: a digression on enumerations
22:42 Outlook: reading messages from mail folders
29:57: Outlook: downloading attachments

Python playlist https://youtube.com/playlist?list=PLNIs-AWhQzckGrdnwITFlXGqiXTCAhWWi

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!