-
Bill Jelen: Microsoft just released a fledgling version of TypeScript in Excel that will, in 20 years or so, supplant VBA
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.