Python has in the last few years become the language of choice for an overwhelming community of data professionals. While Office Scripts will integrate better with Excel and with Microsoft’s Power Suite of tools like Power Automate, I think today’s analysts should look towards languages used more broadly across fields of data science and data engineering. But why limit yourself? I personally think today’s analysts should look towards languages and tools that are more versatile to processing data.

While I don’t think VBA will go away in the next 10 years, Microsoft will definitely be trying to get more users onto Office Scripts. Meanwhile VBA is not getting any younger and is not evolving step by step with leading data science languages like Python.

The challenge there is that while Office Scripts will become more mature we still need to wait a while for them to be fully supported for the desktop version of Excel. The way Microsoft is moving with introduction of Office Scripts it does seem like the Redmond giant will not be planning to invest anymore in expanding VBA, however, will leave it as the designated offline scripting language.

Is visual basic for excel relevant