You can use lambda, JavaScript, any .NET language, any language that knows COM.
Those that only use VBA only have themselves to blame.
Those that only use VBA only have themselves to blame.
- lambda and JavaScript, out of the box in latest versions
- any .NET or COM aware language, PowerShell fits the bill, there is even a mini-IDE installed by default
Not every company uses the latest versions of everything. We finally switched everyone to Windows 10 this year. We were paying for Windows 7 support while making the transition.