The choice of automation tool depends on the need. VBA acts within desktop Excel, with great power but security risks. Office Scripts work in Excel for the web and are triggered from the cloud with Power Automate. Power Query suits data import and cleaning, and formulas are often enough without code.
Example
Cleaning a data export every month: Power Query; scheduling processing in the cloud: Office Scripts and Power Automate.