Understanding the Role of the .xltm Template 1. Understanding the Role of the .xltm Template An .xltm file is an Excel template with macros. When you create a new workbook from this template, all macros, formatting, and settings are automatically included. The idea here is to apply this template to your 107 .xlsx files without opening them one by one. 2. Preparing the .xltm Template Create an .xltm file containing your macro in ThisWorkbook, the desired formatting, and any other standard settings. Save it in an accessible folder, for example, C:\Templates\MacroTemplate.xltm. 3. Organizing the .xlsx Files Place all 107 .xlsx files in a single folder, for example, C:\Work\SourceWorkbook. This will facilitate automated processing by a VBA or PowerShell script.