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

    Home Forums AskWoody blog Bill Jelen: Microsoft just released a fledgling version of TypeScript in Excel that will, in 20 years or so, supplant VBA

    Viewing 1 reply thread
    • Author
      Posts
      • #2154010 Reply
        woody
        Da Boss

        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 aroun
        [See the full post at: Bill Jelen: Microsoft just released a fledgling version of TypeScript in Excel that will, in 20 years or so, supplant VBA]

        3 users thanked author for this post.
      • #2154093 Reply
        RetiredGeek
        AskWoody MVP

        So, I’m good until I’m 97. Guess I don’t have to learn a new language! LOL
        You’d think they would have made PowerScript the Macro Language since they already have a PS module that can read/write Excel files.

        😎

        May the Forces of good computing be with you!

        RG

        PowerShell & VBA Rule!
        Computer Specs

        1 user thanked author for this post.
        • #2154469 Reply
          warrenrumak
          AskWoody Plus

          Language-wise, PowerShell is probably a better replacement for VBA than TypeScript, just because the style of the languages are fairly similar.

          The problem is that PS requires .NET, and using the .NET runtime just to execute macros would incur a pretty significant performance and memory overhead.  .NET also doesn’t run natively in a browser, so they’d have to come up with some weird solution for the web version of Office.

          Office has already included the ability to run add-ins with JavaScript for several years, so adding in TypeScript support is going to be much easier.  It also means that one language is used for writing both add-ins and macros, which is what we had with VBA.

           

    Viewing 1 reply thread

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Bill Jelen: Microsoft just released a fledgling version of TypeScript in Excel that will, in 20 years or so, supplant VBA

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.