VBA may have a bad reputation, but it's still one of the most effective ways to automate repetitive actions in standard XLSX ...

Run Spreadsheet Macro is an activity that executes a specified macro within a macro-enabled workbook and handles arguments and return values as needed. The target is the Excel file selected in Use ...