Python for VBA Developers

About

• Why teach Python to VBA Developers?
• When is it Time to Move on from VBA?
• Conventions Used in this Project

Syntax Translations

• Comments
• Equivalence & Assignment
• Incrementing Variables
• Quotes
• Select-Case Statement Workaround
• Statement Delimiters
• Whitespace
• Datetime Formatting

Breaking Free of the VBE

• Writing VBA Code in Python
• Running Python with VBA
• Who, What, Where, When, and Why PyCharm
• PyCharm's Keymap
• Using Bookmarks
• References
• Print & Assert Statements
• What about the Immediate Window?

The Pandas Library

• Importing Data From Excel
• Filtering a Pandas Dataframe
• Getting a Row Count
• Common Excel Operations Done In Pandas