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.

[@nidhichourasia6515]

my power automate is not triggering the script for xlsm file, it works properly for xlsx file

[@analysiscloud]

If you select (by navigating) the xlsm file in the Power Automate Excel Run Action it will trigger for that file.

[@oqlig3169]

how did you choose a xlsm file?

[@analysiscloud]

Within Power Automate the Action used is an Excel Run Script Action. I navigated to the Excel Macro (.xlsm) file to select it.