News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Bill Jelen: Microsoft just released a fledgling version of TypeScript in Excel that will, in 20 years or so, supplant VBA

    Posted on February 20th, 2020 at 10:57 woody Comment on the AskWoody Lounge

    Bill Jelen has just posted a fascinating video of the “Excel VBA Killer” known as TypeScript.

    For 16 years, people asked me if Excel VBA will be around forever. I always said, “Don’t worry – they can’t kill it until there is a viable replacement with a macro recorder.”

    Today, Microsoft released a public preview of Office Script, which offers a macro recorder that works. More or less. Most of the time. It’s hard to find, but if you have an E3 or E5 Office 365 subscription (can’t try this at home, folks), you can use the new macro recorder to create functioning TypeScript code.

    Jelen figures it’ll take 27 years or so before VBA Excel gets replaced entirely, but this most definitely looks like the way of the (far) future.