Office Scripts allows to automate tasks by recording, editing, and running scripts in Excel on both of web and desktop, it is typescript.
Bookmark generator is good demo to show how the common task works, the main difference than VBA on desktop is UI, which is not existing for Office Scripts, also no way to output to external file, so I output generated bookmark file in new sheet or console as examples.
- run script from Excel Automate tab
- input data from selection of 2 columns: name and url which starting with http or https
- generated bookmark under a folder which name is from active sheet name
- output the bookmark file on console
- run script from Excel Automate tab
- input data from selection of 2 columns: name and url which starting with http or https
- generated bookmark under a folder which name is from active sheet name
- create new sheet 'bookmark' and place bookmark file on A1 cell