Converter, VBA to Office Script.

A converter VBA to Office Script is a challenging task, but with VBA and regular expressions, many common VBA constructs can be converted to Office Scripts.

This converter is intended to create an approach in Office Script and then the user can extend it with his knowledge.

Since VBA and Office Scripts have different syntax and APIs, this converter will convert simple elements such as loops, conditions, and cell operations.

A more complex VBA to Office Scripts converter requires advanced logic to analyze and convert the different syntax and commands of the two languages.

The attached file tries to convert the VBA code into Office Script in a simple way.

 A lot of things are not taken into account, but it can be a useful tool to get started.

I hope it works for you too and if you discover any problems or errors,

I would be happy to hear your feedback.