Run VBA routines from Office Scripts
Trigger VBA routines with an Office Script
VBA is an On prem language so how do we connect it with the online world? Do we use a Power Automate flow? Here is a suggested for the solution:
• A Flow runs an Office Script
• The Office Script creates a new worksheet
• The VBA respond to that NewSheet event and runs its routine.