ex @misk@lemm.ee

  • 2 Posts
  • 5 Comments
Joined 1 year ago
cake
Cake day: July 6th, 2023

help-circle



  • I think it’s just the first step since VBA is in a dire need of a replacement.

    Around the time Office 365 rolled out and replaced Office 2023 at my old job we’ve had a crapload of old VBA tools just refuse to work. Those tools were in use for 10-15 years sometimes with barely any maintenance required.

    Then with O365 some calls to certain 3rd party libraries resulted in Excel crashing without any single error message, stack, nothing. At that time everyone understood they need to get off that ship ASAP, corporate policies got super strict on end user created stuff. PowerBI and Power Automate are not there to replace it and I think MS feels threatened.


  • You don’t need to convince me web is currently at risk of repeat of what we had in late 90s. It doesn’t really have many similarities to what’s happening here because corporate entities are in almost complete power over JS interpreters/compilers due to how web browsers are in position to capture market.

    What Microsoft does here is adding another scripting language to Excel because VBA is outdated shitshow that creates enormous barrier of entry for millions of people that could get way more out of their flagship product. There is a genuine benefit to Microsoft and Excel users to add Python scripting.

    Python is a general purpose / glue language for countless useful libraries and APIs. Excel will be one of many big fishes in that pond, among Tensorflow by Google, PyTorch by Meta and plenty of others. There’s nothing to be gained from breaking Python here. There’s also no room to strong arm non-corporate part of Python world into anything because we’re not married to any particular implementation.

    Microsoft, like most big corporations, is Inherently evil, but not every single thing they do is evil. I’ve worked in enough big corporations to know that they’re so disorganized that you should look at what particular departament does because left hand doesn’t really know what right hand does. Excel team has been incredibly customer facing and deserves benefit of the doubt.