The new strategy for scripting in MS Office ![]() Office Scripts only work on the web version of MS Office and Excelįor months I was curious as to whether Microsoft will move and replace VBA with Typescript. Office Scripts only work on the web version of MS Office and Excel – so don’t expect to be able to start rewriting your scripts yet. Having a scripting language that requires it’s own interpreter or compiler is simply more difficult. Microsoft wants their Office applications to work similarly for any platform, be it Mac, Windows, Android, iOS etc. Top Programming Languages 2021 – Stack Overflow Although my personal feeling is that probably Python would have been a better choice, Microsoft wanted a language that can be run natively on browsers, is more accessible and portable. Typescript is in the top 7 which is an achievement as well especially as both languages have similar syntax. The move to Javascript/Typescript probably made sense for Microsoft as Javascript maintains it #1 position as a popular programming language for years now. Typescript is a language owned by Microsoft and is a superset of Javascript. In recent years/months we did see see appearance of a new scripting language for Excel – TypeScript and Javascript. ![]() Let’s see what’s the story behind Office Scripts vs VBA… The appearance of TypeScript for Excel The Developer window also hasn’t seen many changes and there have been many rumors that VBA will be planned to be replaced with another programming language or platform (like Python). VBA has been around already for more than 20 years and hasn’t been extended for a long time with any new capabilities. ![]() ![]() However, the question was – what is Microsoft planning to do. Many users till date are creating automations and small office use applications on top of Excel and other MS Office solutions for the better or worse, simply due to the ease with which you can extend them. For years now Excel lovers have been anticipating what Microsoft’s move will be in terms of scripting within Microsoft Office.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |