Like MeinBlutIsBlau, I thought this was going to be Microsoft finally ditching VBA for Python as its macro language.
Like MeinBlutIsBlau, I thought this was going to be Microsoft finally ditching VBA for Python as its macro language.
No, its not.
> Packages to allow Python to create/manipulate Excel files have been around for a long time.
Xlwings (1) has been around for a while, itself, and more to the point (2) isn’t just a “package to allow Python to create/manipulate Excel files”. It includes an Excel add-in to allow embedding Python in Excel, using it for purposes similar to VBA.
> Like MeinBlutIsBlau, I thought this was going to be Microsoft finally ditching VBA for Python as its macro language.
Well, it allows users to do that without Microsoft doing it, so that's closer to accurate than the description implied by your dismissal.
There is lambda and JavaScript support.
https://www.microsoft.com/en-us/research/blog/lambda-the-ult...
https://exceljet.net/excel-functions/excel-lambda-function
https://docs.microsoft.com/en-us/office/dev/add-ins/referenc...
Can't you use any language that 'integrates with' Microsoft Scripting Host?
WSH is something quite different. It runs VBScript, which is a different language from VBA. VBA is the same language as Visual Basic 6 and uses the same IDE.