This is a new feature and we can’t wait to hear your feedback. Is it useful for your tasks? Is it easy to use? Just let us know via website or email us.
Use with caution: beta features may contain some bugs and rough edges. To test the feature, take a free trial or update XLTools.
Record and run the same macro on multiple Excel workbooks without coding
- Record the changes as a macro
- Run the macro on multiple workbooks without opening them
- Does not require VBA coding skills
Before you begin, add Loop Macro Format to Excel
How to loop macro through multiple workbooks
- Open one of the workbooks, where you want to make the changes. It will serve as a template.
- Limitation: macros from a Personal Macro Workbook are not available.
- Select the newly recorded macro – see how to record a new macro.
- Check the box Include files in subfolders, and the files will be added
- Uncheck the boxes for the files you want to exclude from processing
- Note: We’ve tried to make the processing as fast as possible. It runs in the background without opening the workbooks. Processing time depends on the number of files to process, file size, the extent of changes, and your computer processing powers.
- “done” – the macro was executed successfully
- “not processed” – the macro was not executed
- “error” – the macro failed with an error
How to record a macro on the fly with the Loop Macro feature
- Assign a descriptive name to the macro
- The option “Store macro in this workbook” will be selected by default
- Adding a shortcut key and description is optional
- Click OK The macro will begin recording Make the necessary changes you want to record.
- Or: use the keyboard shortcut combination Shift + Ctrl + M.
How to push the same changes to multiple workbooks [example]
- Back up the files before you proceed.
- Open one of the workbooks that will serve as a template, e.g. “North America_January”.
- Open XLTools tab In the Automation group, click Loop Macro A window will open.
- Add text in E1: “TOTAL:”
- Add the formula in cell E2: =SUM(C:C)
- Apply Green Data Bar conditional formatting to column C. This will visualize the relative amount of the order.
- Сlick the Stop Recording button on XLTools ribbon The Loop Macro window will open again.