6,127 votes427 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →
Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.
Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.
We’ll provide updates as we progress on this feature request.
Lead Program Manager
ExcelAlex Reed commented
Now I can't speak for Mac users, but if you're a Windows' User, you can technically start integrating the whole VBA object model with Python.
For example, if I want to copy between Excel & PowerPoint using Python I can do this with Win32 Python library, this allows us to plugin to the Windows' API and control different objects.
One of the coolest things about this library is that if use it inside of a Jupyter notebook I can run Python code real time inside of my Excel workbook. This means I can make API calls, dump data into Excel or even upload data to a Python object.
If, for example, you wanted to run Pandas real time inside of Excel this is also possible. The only reason I know this is I've written some scripts that will allow me to do this.
Now the documentation for all of this is few and far between; it's just not covered very well. This is why I started making YouTube videos on it because it changes the way we can look at Office and I know people could benefit from it. Using Python with Excel VBA is one of those things for some reason that never got out, and I don't think people ever realized you could do it.
If you want to check out the videos I made a playlist that covers some introduction topics: