In this tutorial, we show how to create a transpiler, a software that can be useful in a few scenarios: if you have a large codebase in a language that does not fit your needs anymore or if you still want to keep developing in one language, but you need better performance or need to run in a specific environment.
The example transpiler will convertVisual Basic for Applications (VBA) to Visual Basic.NET (VB.NET) code. There are companies that need to keep using VBA because it is a simple language used by non-developers inside Excel. However, there could also be a need for increased performance or to mix calculations made by analysts with parts developed by professional developers. In such cases, individuals can transpile from VBA to VB.NET and let everything run in a single environment.