Channel: WiseOwlTutorials

Category: Education

Tags: compythonfree tutorialonline trainingfree trainingonline tutorialexcelvbatutorialoutlookwordwise owlprogramming

Description: By Andy Brown Download files and exercises for this tutorial from 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: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link 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 youtube.com/playlist?list=PLNIs-AWhQzckGrdnwITFlXGqiXTCAhWWi Visit 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!