Your script can manipulate data, perform common Excel functions such as graph creation or automatically input data into specific cells. Only Visual Basic code can be used with the VBA editor.

How to create a script in Excel for the web At this point, you have a conceptual idea of what Office Scripts and TypeScript are, so let’s move on and create a script in Excel for the Web.