what is the difference between vba and python?
The most obvious difference is that VBA is limited to automation in Microsoft Office products, while Python can run under all sorts of operating systems, for a wide variety of purposes. Dropbox is written in Python, as are large parts of Google's software for instance.