Compare Python to VBA

Both Python and VBA are designed to create programs quickly.

When you have to compare programming languages to each other, such as Python and VBA, it can be difficult to know where to start. They are both object-oriented languages, but when you consider their differences, it is best to start at the lowest level of a language and work your way up. When comparing these two, this means comparing how the two languages make executable files, contrasting syntax in the two languages, and how programmers move beyond terminal applications in the respective languages.

Instructions

1. Consider how the two languages convert source code into machine code. VBA is a compiled language, whereas Python is an interpreted language. Consider how this distinction will determine the platforms on which programs coded in the two languages will be able to run.

2. Look at the syntax utilized by Python and VBA. Your reading should include declaring classes, methods and calling class methods in the two languages.

3. Look at the different ways which programmers create graphical user interfaces in VBA as opposed to Python. Compare the graphical editor that allows VBA programmers to create a user interface by dragging and dropping components into a window that generates code, while Python developers have to write out code using interface libraries themselves.

References

• Python: About
• Microsoft Developers Network: Getting Started with Visual Basic