sancarn / awesome-vba

A curated list of awesome VBA/VB6 frameworks, libraries, software and resources
Other
290 stars 32 forks source link

Section of office scripts for Office365? #22

Open eduo opened 8 months ago

eduo commented 8 months ago

Since Office365 web versions only support Office Scripts and since web-downloaded files do not execute macros by default, more and more people are trying to use Office Scripts for automations.

Are there any plans to add a section for these Office Scripts in the future?

sancarn commented 8 months ago

I feel that belongs in it's own awesome list.

As I see it, there should likely be a hierarchy:

awesome-msoffice
|- awesome-vba
|- awesome-officejs
|- awesome-officescripts
|- awesome-excel
   |- awesome-formulae
|- awesome-word
...

Would be happy to add these awesome lists as links in the header of this repo.

Personally, I do struggle to see anything "awesome" about OfficeScripts at the moment 😅 Apart from the availability to code in another language.

eduo commented 8 months ago

I admit the biggest advantage thing about office scripts is that they're the only option for cross-platform (which as of today includes web, but not office 365 embedded in teams, and only pretty recent versions of Desktop excel).

I honestly wish Microsoft was trying harder to make something that works across their product offering but it's true that for the time being it's still growing and choosing to have no backwards compatibility is painful)